How sunbos/sqlseed works
sqlseed generates reproducible test rows for existing SQLite and PostgreSQL schemas, with Python, terminal, browser, and MCP entry points. The main path reads schema and reusable rules, infers or applies column generators, orders related tables, and previews or inserts rows. Optional AI suggests rules and analyzes or repairs configurations; it is not required for core generation. The README documents these capabilities, while sampled source confirms the CLI, MCP, query, validator, repair, and web navigation responsibilities; some unsampled subsystem links are therefore omitted.
Main entry points: __init__.py Data orchestrator · orchestrator.py Analyze and heal · _generation.py Row generation · main.py Terminal CLI
Components 21
Generation core
- Rules and config
src/sqlseed/config/loader.py - Data orchestrator
src/sqlseed/core/orchestrator/__init__.py - Schema mapping
src/sqlseed/core/orchestrator/_query.py - Dependency ordering
src/sqlseed/core/relation.py - Row generation
src/sqlseed/core/orchestrator/_generation.py - Sample preview
src/sqlseed/core/orchestrator/_generation.py
User interfaces
- Python API
src/sqlseed/__init__.py - Terminal CLI
plugins/sqlseed-cli/src/sqlseed_cli/main.py - Web workbench
plugins/sqlseed-web/src/sqlseed_web/app.py - Browser UI
plugins/sqlseed-web/src/sqlseed_web/static/js/app.js - Core MCP tools
plugins/mcp-server-sqlseed/src/mcp_server_sqlseed/server.py
AI assistance
- AI commands
plugins/sqlseed-ai/src/sqlseed_ai/cli/ai_commands.py - AI rule suggestions
plugins/sqlseed-ai/src/sqlseed_ai/ai_mediator.py - Analyze and heal
plugins/sqlseed-ai/src/sqlseed_ai/auto_heal/orchestrator.py - Constraint validator
plugins/sqlseed-ai/src/sqlseed_ai/validator/main.py - Rule repair
plugins/sqlseed-ai/src/sqlseed_ai/repair/pipeline.py
Database and generators
- Target database
src/sqlseed/database/sqlalchemy_adapter.py - Value providers
src/sqlseed/generators/registry.py
Extensions
- Plugin manager
src/sqlseed/plugins/manager.py
Other components
- User
- Model service
Connections 26
- User → Python API: calls
- User → Terminal CLI: runs
- User → Browser UI: uses
- User → Core MCP tools: invokes tools
- Browser UI → Web workbench: requests
- Python API → Data orchestrator: starts generation
- Terminal CLI → Rules and config: loads rules
- Terminal CLI → Data orchestrator: fills or previews
- Core MCP tools → Data orchestrator: fills table
- Core MCP tools → Schema mapping: reads mapping
- Rules and config → Data orchestrator: supplies rules
- Data orchestrator → Schema mapping: reads metadata
- Schema mapping → Target database: inspects schema
- Data orchestrator → Dependency ordering: orders tables
- Data orchestrator → Row generation: coordinates rows
- Row generation → Value providers: requests values
- Row generation → Target database: inserts rows
- Sample preview → Row generation: samples rules
- AI commands → AI rule suggestions: suggests rules
- AI commands → Analyze and heal: analyzes or heals
- Analyze and heal → Constraint validator: validates config
- Analyze and heal → Rule repair: repairs violations
- Rule repair → Constraint validator: revalidates partial fixes
- AI rule suggestions → Model service: requests suggestions
- Analyze and heal → Model service: requests rule help
- Data orchestrator → Plugin manager: loads extensions