Schema Input

DBSprout supports 7 schema input methods. All produce the same unified DatabaseSchema model internally.

Live Database Introspection

Connect directly to a running database:

# PostgreSQL
dbsprout init --db postgresql://user:pass@host:5432/dbname

# MySQL
dbsprout init --db mysql://user:pass@host:3306/dbname

# SQLite
dbsprout init --db sqlite:///path/to/database.db

# MSSQL
dbsprout init --db mssql://user:pass@host:1433/dbname

DBSprout uses SQLAlchemy’s Inspector to read tables, columns, primary keys, foreign keys, indexes, and constraints.

SQL DDL Files

Parse CREATE TABLE statements from a .sql file:

dbsprout init --file schema.sql

Supports PostgreSQL, MySQL, and SQLite DDL dialects.

DBML

Parse DBML schema files:

dbsprout init --file schema.dbml

Prisma Schema

Parse Prisma schema files:

dbsprout init --file prisma/schema.prisma

Mermaid ER Diagrams

Parse Mermaid entity-relationship diagrams:

dbsprout init --file schema.mmd

PlantUML

Parse PlantUML entity diagrams:

dbsprout init --file schema.puml

Django Models (Planned)

Parse Django model definitions:

dbsprout init --file models.py --parser django