Skip to main content

A fast Tarantool Database connector for Python/asyncio.

Project description


Build PyPI Maintainability

asynctnt is a high-performance Tarantool database connector library for Python/asyncio. It was highly inspired by asyncpg module.

asynctnt requires Python 3.6 or later and is supported for Tarantool versions 1.6+.


Use pip to install:

$ pip install asynctnt


Documentation is available here.

Key features

  • Support for all the basic requests that Tarantool supports. This includes: insert, select, update, upsert, call, eval, execute.
  • Full support for SQL, including prepared statements.
  • Support for interactive transaction via Tarantool streams.
  • Support of Decimal, UUID and datetime types natively.
  • Support for parsing custom errors.
  • Schema fetching on connection establishment, so you can use spaces and indexes names rather than their ids, and auto refetching if schema in Tarantool is changed
  • Auto reconnect. If connection is lost for some reason - asynctnt will start automatic reconnection procedure (with authorization and schema fetching, of course).
  • Ability to use dicts for tuples with field names as keys in DML requests (select, insert, replace, delete, update, upsert). This is possible only if space.format is specified in Tarantool. Field names can also be used in update operations instead of field numbers. Moreover, tuples are decoded into the special structures that can act either as tuples or by dicts with the appropriate API.
  • All requests support specification of timeout value, so if request is executed for too long, asyncio.TimeoutError is raised.

Basic Usage

Tarantool config:

box.cfg {
    listen = ''

box.once('v1', function()
    box.schema.user.grant('guest', 'read,write,execute', 'universe')

    local s = box.schema.create_space('tester')
        { name = 'id', type = 'unsigned' },
        { name = 'name', type = 'string' },
        { name = 'uuid', type = 'uuid' },

Python code:

import uuid
import asyncio
import asynctnt

async def main():
    conn = asynctnt.Connection(host='', port=3301)
    await conn.connect()

    for i in range(1, 11):
        await conn.insert('tester', [i, 'hello{}'.format(i), uuid.uuid4()])

    data = await'tester', [])
    tup = data[0]
    print('tuple:', tup)
    print(f'{tup[0]=}; {tup["id"]=}')
    print(f'{tup[1]=}; {tup["name"]=}')
    print(f'{tup[2]=}; {tup["uuid"]=}')

    await conn.disconnect()


(note that you can simultaneously access fields either by indices or by their names)

tuple: <TarantoolTuple id=1 name='hello1' uuid=UUID('ebbad14c-f78c-42e8-bd12-bfcc564443a6')>
tup[0]=1; tup["id"]=1
tup[1]='hello1'; tup["name"]='hello1'
tup[2]=UUID('ebbad14c-f78c-42e8-bd12-bfcc564443a6'); tup["uuid"]=UUID('ebbad14c-f78c-42e8-bd12-bfcc564443a6')


Tarantool 2.x brought out an SQL interface to the database. You can easily use it in asynctnt

box.cfg {
    listen = ''

box.once('v1', function()
    box.schema.user.grant('guest', 'read,write,execute', 'universe')

        create table users (
            id int primary key,
            name text
import asyncio
import asynctnt

async def main():
    conn = asynctnt.Connection(host='', port=3301)
    await conn.connect()

    await conn.execute("insert into users (id, name) values (?, ?)", [1, 'James Bond'])
    await conn.execute("insert into users (id, name) values (?, ?)", [2, 'Ethan Hunt'])
    data = await conn.execute('select * from users')

    for row in data:

    await conn.disconnect()


<TarantoolTuple ID=1 NAME='James Bond'>
<TarantoolTuple ID=2 NAME='Ethan Hunt'>

More about SQL features in asynctnt please refer to the documentation


Two performance tests were conducted:

  1. Seq -- Sequentially calling 40k requests and measuring performance
  2. Parallel -- Sending 200k in 300 parallel coroutines

On all the benchmarks below wal_mode = none. Turning uvloop on has a massive effect on the performance, so it is recommended to use asynctnt with it

Benchmark environment

  • MacBook Pro 2020
  • CPU: 2 GHz Quad-Core Intel Core i5
  • Memory: 16GB 3733 MHz LPDDR4X


box.cfg{wal_mode = 'none'}
Seq (uvloop=off) Seq (uvloop=on) Parallel (uvloop=off) Parallel (uvloop=on)
ping 12940.93 19980.82 88341.95 215756.24
call 11586.38 18783.56 74651.40 137557.25
eval 10631.19 17040.57 61077.84 121542.42
select 9613.88 16718.97 61584.07 152526.21
insert 10077.10 16989.06 65594.82 135491.25
update 10832.16 16562.80 63003.31 121892.28
execute 10431.75 16967.85 58377.81 96891.61


asynctnt is developed and distributed under the Apache 2.0 license.


  1. Tarantool - in-memory database and application server.
  2. aiotarantool - alternative Python/asyncio connector
  3. asynctnt-queue - bindings on top of asynctnt for tarantool-queue

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

asynctnt-2.0.1.tar.gz (435.9 kB view hashes)

Uploaded source

Built Distributions

asynctnt-2.0.1-cp310-cp310-win_amd64.whl (579.8 kB view hashes)

Uploaded cp310

asynctnt-2.0.1-cp310-cp310-win32.whl (548.3 kB view hashes)

Uploaded cp310

asynctnt-2.0.1-cp39-cp39-win_amd64.whl (586.6 kB view hashes)

Uploaded cp39

asynctnt-2.0.1-cp39-cp39-win32.whl (554.6 kB view hashes)

Uploaded cp39

asynctnt-2.0.1-cp38-cp38-win_amd64.whl (586.3 kB view hashes)

Uploaded cp38

asynctnt-2.0.1-cp38-cp38-win32.whl (554.7 kB view hashes)

Uploaded cp38

asynctnt-2.0.1-cp37-cp37m-win_amd64.whl (578.5 kB view hashes)

Uploaded cp37

asynctnt-2.0.1-cp37-cp37m-win32.whl (551.9 kB view hashes)

Uploaded cp37

asynctnt-2.0.1-cp36-cp36m-win_amd64.whl (595.7 kB view hashes)

Uploaded cp36

asynctnt-2.0.1-cp36-cp36m-win32.whl (563.9 kB view hashes)

Uploaded cp36

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page