tortoise/tortoise-orm

Health v2 · maintenance only

Adoption not part of the score

5613 stars · 499 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Tortoise ORM is an asyncio-native Object Relational Mapper for Python with a Django-inspired API, supporting SQLite, PostgreSQL, MySQL, SQL Server, and Oracle. It provides model definitions, relations, queries, and schema migrations for async Python applications.

Use cases

• use an async ORM for a FastAPI backend
• define database models with relations in asyncio Python
• migrate from Django ORM to an async stack
• query PostgreSQL without writing raw SQL in async code
• manage schema migrations for an async Python app
• benchmark-friendly ORM for high-throughput database reads and writes

When to choose

• your application is asyncio-based and needs database access
• you want a Django-like model and query API in async Python
• you need support for multiple relational databases including PostgreSQL and MySQL
• you want a lightweight ORM with good performance

When to avoid

• you need a fully synchronous ORM like Django ORM or SQLAlchemy sync
• your project requires long-term API stability, as breaking changes are expected
• you need NoSQL or non-relational database support
• you rely on Python versions older than 3.10

Facets

library · maturity active

orm database database-driver databases backend web-development python cross-platform asyncio django-inspired postgresql mysql sqlite migrations relational-database

Member repositories

For agents

markdown · JSON · MCP: product_card(name="tortoise/tortoise-orm")