Type-Safe Python ORMs and Query Builders
Discover Python libraries that provide robust type checking and autocompletion for database interactions and queries.
Type-Safe Python ORMs and Query Builders
Find the best repos with AI.We'll search the best matching repositories with AI.
- coleifer/peewee
coleifer/peewee
11,971View on GitHubPeewee is a SQL object-relational mapper and query builder that provides an object-oriented interface for mapping application classes to relational database tables. It functions as a relational database toolkit for managing schemas, executing migrations, and handling complex table relationships. The project distinguishes itself by providing an asyncio database driver for non-blocking database operations, ensuring event loop responsiveness. It also supports semi-structured data storage, allowing the storage and querying of flexible JSON documents within traditional relational database systems.
Peewee is a mature, feature-rich Python ORM that provides a fluent query builder, async support, and migration tools, though it lacks the native static type-checking capabilities found in more modern, type-hint-first alternatives.
PythonAsynchronous Database DriversAsynchronous DriversObject-Relational Mappers - sqlalchemy/sqlalchemy
sqlalchemy/sqlalchemy
11,612View on GitHubSQLAlchemy is a comprehensive Python SQL toolkit and object-relational mapper that provides a full suite of tools for interacting with relational databases. It serves as a foundational layer for database connectivity, offering both a high-level object-oriented interface for data persistence and a programmatic SQL expression language for constructing complex, dialect-agnostic queries. The project distinguishes itself through its sophisticated unit of work persistence, which coordinates atomic transactions and tracks object state changes to minimize redundant database operations. It provides a
SQLAlchemy is the industry-standard Python ORM that provides a robust, type-safe query builder, comprehensive async support, and extensive database migration capabilities, making it the definitive tool for this category.
PythonAsynchronous Database DriversObject-Relational MappersSQL Dialect Adapters - fastapi/sqlmodel
fastapi/sqlmodel
18,137View on GitHubSQLModel is a type-safe object-relational mapping library for Python that integrates database schema definitions with data validation logic. By combining these two roles into a single class, it allows developers to manage relational data structures and enforce data integrity for web APIs simultaneously. The framework is built to support asynchronous database operations, enabling high-performance applications to execute queries and transactions without blocking the main execution thread. The library distinguishes itself by leveraging Python type hints to provide IDE autocompletion and compile-
SQLModel is a type-safe ORM built on SQLAlchemy and Pydantic that provides native support for static type checking, IDE autocompletion, and asynchronous database operations, making it a perfect fit for your requirements.
PythonAsynchronous Database DriversDatabase ORMs - geldata/gel
geldata/gel
14,065View on GitHubGel is an object-relational database system that models data as a graph of interconnected objects. By utilizing a strongly typed schema, it enables complex relational queries and polymorphic data structures without the need for traditional join tables. The system integrates native vector storage and similarity search operators, allowing it to function as both a relational and a vector database for semantic data retrieval. The platform distinguishes itself through a comprehensive suite of developer-centric automation tools. It features a declarative migration system that tracks and versions sc
Gel is a graph-relational database system that provides a type-safe query builder and client library for Python, though it functions as a complete database engine rather than a traditional ORM for existing SQL databases.
PythonDatabase MigrationsMigration Generation
