Database Configuration

Astris provides an out-of-the-box database layer powered by SQLModel, SQLAlchemy 2.0, and Alembic.

Connection Strings (DATABASE_URL)

Set your database connection URL in your project's .env file:

SQLite (Default for Local Development)

DATABASE_URL=sqlite:///database/app.db

PostgreSQL

DATABASE_URL=postgresql+psycopg://user:password@localhost:5432/my_database

MySQL

DATABASE_URL=mysql+aiomysql://user:password@localhost:3306/my_database

Engine Configuration

The database engine is configured automatically by the Astris kernel on startup via astris.database.db.

You can configure query logging in .env:

# Print raw SQL queries to console
DB_ECHO=true

Next Steps

• Define tables and models: SQLModel Models.
• Execute queries and transactions: Queries & CRUD.