Tortoise ORM

About Tortoise ORM

Easy-to-use asyncio ORM inspired by Django. Designed for async/await syntax, making it perfect for asynchronous applications and modern Python development.

Key Features

• 1Async-first ORM built for Python's asyncio ecosystem
• 2Django-inspired API: familiar field types and QuerySet interface
• 3Aerich migration tool for schema versioning in async projects
• 4Works with asyncpg (PostgreSQL), aiosqlite, and aiomysql
• 5Pydantic integration for automatic serialization of model instances

How Python Data Engineers Use Tortoise ORM

Data engineers building async data APIs or streaming ingestion services use Tortoise ORM to perform non-blocking database reads and writes within FastAPI or aiohttp applications. Awaiting QuerySet operations keeps the event loop free while the database executes queries, which is critical in high-concurrency data ingestion scenarios.