coleifer/peewee

Health v2 · maintenance only

Adoption not part of the score

11986 stars · 1382 forks observed · 2026-08-28

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

Peewee is a small, expressive Python ORM with a flexible query builder that supports SQLite, MySQL/MariaDB, and PostgreSQL, plus asyncio backends. It is a single dependency-free module in production use since 2010, with schema migrations and framework integrations for Flask, FastAPI, and Pydantic.

Use cases

• define database models and query tables in python
• use an orm with sqlite in a small python app
• add postgresql or mysql persistence to a flask or fastapi app
• run async database queries with asyncio
• generate and run schema migrations for a python project
• write raw sql with a lightweight query builder
• avoid heavy orms like sqlalchemy for simple projects

When to choose

• you want a lightweight, easy-to-learn ORM with no required dependencies
• your app uses SQLite, MySQL/MariaDB, or PostgreSQL in Python
• you need asyncio database access built on standard async drivers
• you want expressive query building while retaining full SQL power

When to avoid

• you need a multi-database ORM with advanced features like SQLAlchemy's ecosystem
• you require an async-first ORM with deep async ecosystem integration
• you need databases beyond the DB-API 2.0 drivers Peewee supports

Facets

library · maturity stable

orm database-driver database databases web-development backend developer-tools python cross-platform query-builder asyncio sqlite postgresql mysql schema-migrations flask fastapi

Member repositories

For agents

markdown · JSON · MCP: product_card(name="coleifer/peewee")