Production infrastructure for AI agents

Website · Documentation · Guides · Core · Template · Discord

systemprompt-database

PostgreSQL infrastructure for systemprompt.io AI governance. SQLx-backed pool, generic repository traits, and compile-time query verification. Provides database abstraction via SQLx with repository patterns, transaction helpers, and administrative utilities.

Layer: Infra — infrastructure primitives (database, security, events, etc.) consumed by domain crates. Part of the systemprompt-core workspace.

Overview

Provides database abstraction via SQLx with repository patterns, transaction helpers, and administrative utilities.

Architecture

database/
├── Cargo.toml
├── CHANGELOG.md
├── README.md
├── schema/
│   ├── extension_migrations.sql
│   └── functions.sql
└── src/
    ├── lib.rs
    ├── error.rs
    ├── extension.rs
    ├── admin/
    │   ├── mod.rs
    │   ├── admin_sql.rs
    │   ├── identifier.rs
    │   ├── introspection.rs
    │   └── query_executor.rs
    ├── lifecycle/
    │   ├── mod.rs
    │   ├── migrations.rs
    │   ├── validation.rs
    │   └── installation/
    │       ├── mod.rs
    │       └── extension.rs
    ├── models/
    │   ├── mod.rs
    │   ├── info.rs
    │   ├── query.rs
    │   └── transaction.rs
    ├── repository/
    │   ├── mod.rs
    │   ├── base.rs
    │   ├── cleanup.rs
    │   ├── info.rs
    │   └── service/
    │       ├── mod.rs
    │       ├── model.rs
    │       └── repo.rs
    └── services/
        ├── mod.rs
        ├── database.rs
        ├── display.rs
        ├── executor.rs
        ├── provider.rs
        ├── schema_linter.rs
        ├── transaction.rs
        └── postgres/
            ├── mod.rs
            ├── conversion.rs
            ├── ext.rs
            ├── introspection.rs
            └── transaction.rs

extension.rs

DatabaseExtension implementation that registers the crate's base schema (functions.sql, extension_migrations.sql) via the workspace extension framework.

admin/

Administrative database utilities for introspection and constrained query execution.

lifecycle/

Database setup, migration, and validation.

models/

Data structures for database operations.

repository/

Repository pattern building blocks.

services/

Core database services and providers.

services/postgres/

PostgreSQL-specific implementation of the provider surface.

Usage

[dependencies]
systemprompt-database = "0.9.0"

use systemprompt_database::{DatabaseResult, DbPool, with_transaction};

async fn example(pool: &DbPool) -> DatabaseResult<()> {
    with_transaction(pool, |tx| Box::pin(async move {
        // Execute queries within transaction
        Ok(())
    })).await
}

use systemprompt_database::{DatabaseResult, DbPool, with_transaction};

async fn count_users(pool: &DbPool) -> DatabaseResult<i64> {
    with_transaction(pool, |tx| Box::pin(async move {
        let row: (i64,) = sqlx::query_as("SELECT COUNT(*) FROM users")
            .fetch_one(&mut **tx)
            .await?;
        Ok(row.0)
    }))
    .await
}

Public API

Types

Traits

Functions

Macros

Re-exports

From systemprompt-traits: DbValue, ToDbValue, FromDbValue, JsonRow, parse_database_datetime

From systemprompt-identifiers: UserId, TaskId, SessionId, ContextId, TraceId, ArtifactId, ExecutionStepId, SkillId, ContentId, FileId, ClientId, TokenId, LogId

From sqlx: PgPool, Pool, Postgres, Transaction, Json

Dependencies

• systemprompt-traits — core traits
• systemprompt-identifiers — typed identifiers
• systemprompt-models — shared model types
• systemprompt-extension — extension framework registration
• sqlx — PostgreSQL driver with compile-time-verified macros
• tokio — async runtime
• serde / serde_json — serialization
• chrono — timestamps
• uuid — UUID support
• rust_decimal — decimal support
• base64 — encoded value support
• thiserror — error derivation
• async-trait — dyn-compatible async traits
• tracing — structured logging
• inventory — extension registration

License

BSL-1.1 (Business Source License). Source-available for evaluation, testing, and non-production use. Production use requires a commercial license. Each version converts to Apache 2.0 four years after publication. See LICENSE.

systemprompt.io · Documentation · Guides · Live Demo · Template · crates.io · docs.rs · Discord

Infra layer · Own how your organization uses AI.