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_request_session*`	`manual`, `autocommit`, `autocommit_include_redirect`	`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())`	`manual`, `autocommit`, `autocommit_include_redirect`	—	`FilterConfig` (`db_ext.provide_filters(...)` / `provide_filters(...)`)	`sqlspec` CLI
Starlette	`sqlspec.extensions.starlette`	`sqlspec[starlette]`	`db_plugin.get_session(request)`	`manual`, `autocommit`, `autocommit_include_redirect`	—	—	`sqlspec` CLI
Flask	`sqlspec.extensions.flask`	`sqlspec[flask]`	`plugin.get_session()` (`g`-scoped)	`manual`, `autocommit`, `autocommit_include_redirect`	—	—	`sqlspec` CLI
Sanic	`sqlspec.extensions.sanic`	`sqlspec[sanic]`	`db_plugin.get_session(request)` (`request.ctx`)	`manual`, `autocommit`, `autocommit_include_redirect`	—	—	`sqlspec` CLI
Dishka	`dishka`	`dishka`	`FromDishka[DriverT]` (`Scope.REQUEST`)	Explicit session or service scope	Combines with any adapter store	Combines with `SQLSpecAsyncService` / `SQLSpecSyncService`	Shared `Scope.APP` container across web, CLI, and workers
OpenTelemetry	`sqlspec.extensions.otel`	`sqlspec[otel]` (`opentelemetry-api`)	`enable_tracing(...)` (`ObservabilityConfig`)	—	`SpanManager` (`db.system`, `db.operation`)	—	—
Prometheus	`sqlspec.extensions.prometheus`	`sqlspec[prometheus]` (`prometheus-client`)	`enable_metrics(...)` (`StatementObserver`)	—	`PrometheusStatementObserver` (`Counter`, `Histogram`)	—	—

Shared Extension Configuration Pattern¶

Framework and extension settings live on each adapter configuration inside extension_config, keeping pool settings, statement compilation, and framework integration in one typed declaration:

from sqlspec.adapters.asyncpg import AsyncpgConfig

config = AsyncpgConfig(
    connection_config={
        "dsn": "postgresql://localhost/app",
        "min_size": 2,
        "max_size": 20,
    },
    extension_config={
        "litestar": {"session_key": "db_session", "commit_mode": "autocommit"},
        "events": {"backend": "notify_queue", "event_poll_interval": 1.0},
        "adk": {
            "session_table": "adk_session",
            "events_table": "adk_event",
            "memory_table": "adk_memory",
            "memory_use_fts": True,
        },
    },
)

Choosing an Integration¶

ASGI & WSGI Web Frameworks: Use Litestar, FastAPI, Starlette, Flask, or Sanic when you want automatic pool lifecycle hooks (lifespan / on_startup / teardown_appcontext), per-request session cleanup, correlation ID middleware, and HTTP status-aware transaction commit modes.
Multi-Entrypoint IoC Containers: Use Dishka when HTTP handlers, background workers, and CLI commands share a single Provider graph with Scope.APP pools and Scope.REQUEST driver sessions.
AI Agents & Long-Term Memory: Use Google ADK to persist agent conversation sessions, events, versioned artifacts, and full-text or vector/hybrid RRF memories across SQLite, PostgreSQL (pgvector / pg_textsearch), Oracle 26ai, Cloud Spanner, DuckDB, MySQL, SQL Server, and IBM Db2.
Transactional Pub/Sub & Competing Consumers: Use Events & Queues for PostgreSQL LISTEN/NOTIFY, durable notify_queue wakeups, Oracle Advanced Queuing (aq / txeventq), or portable table-backed queues (poll_queue).
Observability & Metrics: Use OpenTelemetry (sqlspec.extensions.otel.enable_tracing) and Prometheus (sqlspec.extensions.prometheus.enable_metrics) for distributed tracing spans and query duration histograms; see Observability & Telemetry and the Extensions Reference.

GeezerVison

Framework and Ecosystem Integrations¶

Integration Matrix¶

Shared Extension Configuration Pattern¶

Choosing an Integration¶