Framework and Ecosystem Integrations¶
SQLSpec ships first-party framework plugins and ecosystem extensions under sqlspec.extensions.* plus native Dishka dependency-injection patterns. Every integration manages connection pools at application startup/shutdown and provides request- or task-scoped driver sessions with configurable transaction commit behavior.
Integration Matrix¶
| Integration | Module / Package | Install Extra | Request DI / Entrypoint | Commit Modes | Server-Side Stores / Backends | Filter Providers | CLI Integration |
|---|---|---|---|---|---|---|---|
| Litestar | sqlspec.extensions.litestar |
sqlspec[litestar] |
Provide (db_session, db_connection, db_pool), provide_db_session* |
autocommit (default), autocommit_include_redirect, manual |
Store, SQLSpecChannelsBackend |
FilterConfig (create_filter_dependencies) |
litestar db ..., litestar sessions delete-expired |
| Google ADK | sqlspec.extensions.adk |
sqlspec[adk] |
Runner / Agent services | Atomic store operations | SQLSpecSessionService, SQLSpecMemoryService, SQLSpecArtifactService |
Vector, FTS, and Hybrid RRF memory search | sqlspec adk memory ... |
| Events & Queues | sqlspec.extensions.events |
Built-in (sqlspec) |
SyncEventChannel / AsyncEventChannel |
Transactional publish / ack | notify, notify_queue, poll_queue, Oracle aq / txeventq |
Channel + metadata envelope filtering | Schema provisioning via MigrationCommands |
| FastAPI | sqlspec.extensions.fastapi |
sqlspec[fastapi] |
Depends(db_ext.provide_session()) |
autocommit (default), autocommit_include_redirect, manual |
— | FilterConfig (db_ext.provide_filters(...) / provide_filters(...)) |
sqlspec CLI |
| Starlette | sqlspec.extensions.starlette |
sqlspec[starlette] |
db_plugin.get_session(request) |
autocommit (default), autocommit_include_redirect, manual |
— | — | sqlspec CLI |
| Flask | sqlspec.extensions.flask |
sqlspec[flask] |
plugin.get_session() (g-scoped) |
autocommit (default), autocommit_include_redirect, manual |
— | — | sqlspec CLI |
| Sanic | sqlspec.extensions.sanic |
sqlspec[sanic] |
db_plugin.get_session(request) (request.ctx) |
autocommit (default), autocommit_include_redirect, manual |
— | — | sqlspec CLI |
| Dishka |