Installation

Install SQLSpec with the Litestar extra and a database adapter.

PostgreSQL (asyncpg)

uv

uv add "sqlspec[asyncpg,litestar]"

pip

pip install "sqlspec[asyncpg,litestar]"

Poetry

poetry add "sqlspec[asyncpg,litestar]"

PDM

pdm add "sqlspec[asyncpg,litestar]"

PostgreSQL (psycopg)

uv

uv add "sqlspec[psycopg,litestar]"

pip

pip install "sqlspec[psycopg,litestar]"

Poetry

poetry add "sqlspec[psycopg,litestar]"

PDM

pdm add "sqlspec[psycopg,litestar]"

SQLite (async)

uv

uv add "sqlspec[aiosqlite,litestar]"

pip

pip install "sqlspec[aiosqlite,litestar]"

Poetry

poetry add "sqlspec[aiosqlite,litestar]"

PDM

pdm add "sqlspec[aiosqlite,litestar]"

MySQL

uv

uv add "sqlspec[asyncmy,litestar]"

pip

pip install "sqlspec[asyncmy,litestar]"

Poetry

poetry add "sqlspec[asyncmy,litestar]"

PDM

pdm add "sqlspec[asyncmy,litestar]"

Requirements

• Python 3.11+

• Litestar 2.23+

• A compatible database adapter (async recommended for web request concurrency)

Next Steps

Proceed to Quickstart to wire the plugin into your Litestar app.