# python-gino/gino

GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

Repository: https://github.com/python-gino/gino
Canonical: https://ross.abutalabs.com/products/gino
Homepage: https://python-gino.org/
Language: Python
License: NOASSERTION
License Family: other
Topics: orm, asyncio, sqlalchemy, asyncpg, python3, gino, hacktoberfest
Last push: 2022-02-12T20:35:18+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3330, "days_push": 1663, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 2793, forks 149 (observed 2026-08-28T04:07:22.259019+00:00)

## What it is
GINO is a lightweight asynchronous ORM for Python built on top of SQLAlchemy core, supporting PostgreSQL via asyncpg and MySQL via aiomysql. It provides async engine/connection APIs, CRUD model objects, and compatibility with the SQLAlchemy ecosystem such as Alembic migrations.

## Use cases
- use an async ORM with PostgreSQL in a FastAPI app
- port legacy SQLAlchemy core code to asyncio
- manage database transactions and connections in async Python
- build CRUD models for asyncpg without raw SQL
- use Alembic migrations with an async database layer
- query PostgreSQL JSONB columns from async Python

## When to choose
- you need an asyncio-native database layer for PostgreSQL or MySQL
- you want SQLAlchemy core query building with async execution
- you use FastAPI, Starlette, aiohttp, Sanic, Tornado, or Quart and need async DB access

## When to avoid
- you need SQLAlchemy 2.0 support or active development - the project has been quiet since 2022
- you prefer the official asyncio support built into SQLAlchemy itself
- you need databases other than PostgreSQL or MySQL

## Facets
- artifact type: library
- maturity: maintenance
- function: orm, database-driver, database
- domain: databases, backend, web-development
- platform: python, windows
- tags: asyncio, sqlalchemy, asyncpg, postgresql, mysql, aiomysql, fastapi, linux, macos

## Member repositories
- python-gino/gino (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:22.259019+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T08:14:50.422481+00:00, confidence not recorded.
  - readme: https://github.com/python-gino/gino (fetched 2026-08-28T04:07:22.259019+00:00, sha ae0fec337574)
  - homepage: https://python-gino.org/ (fetched 2026-08-29T09:55:06.019098+00:00, sha b98dcc0ffb77)
  - site_page: https://python-gino.org/docs (fetched 2026-08-29T09:55:06.021639+00:00, sha 3e99076248fe)
  - site_page: https://python-gino.org/docs/en/master/index.html (fetched 2026-08-29T09:55:06.023357+00:00, sha edd196cd654d)
  - site_page: https://python-gino.org/docs/en/master/how-to/schema.html (fetched 2026-08-29T09:55:06.024972+00:00, sha 4921f6ee2b89)
  - registry_pypi: https://pypi.org/pypi/gino/json (fetched 2026-08-29T09:55:06.027508+00:00, sha 5d636f4b7590)
- Data as of 2026-08-30T08:39:29.467469+00:00.
