Real-World Use Cases

See how Schema2AI solves real development challenges across different scenarios

Brownfield: Modernizing Legacy Systems

Scenario: You have an existing database with years of production data and want to build modern APIs

Solution: Use s2ai.import to extract

Key Benefits

  • Extract schema from existing database using s2ai.import
  • Generate schema.mmd automatically
  • Build modern REST API on top of legacy data
  • Add RBAC and validation without changing database
  • Gradually migrate to new architecture

Implementation Steps

  1. 1
    Run s2ai.import on existing database
  2. 2
    Review and refine generated schema.mmd
  3. 3
    Use s2ai.builder to generate API server
  4. 4
    Deploy s2ai.server
  5. 5
    Connect s2ai.face for instant admin UI

Greenfield: Rapid API Development

Scenario: Starting a new project and need to build a complete API quickly

Solution: Write schema.mmd and generate everything

Key Benefits

  • Define your data model in schema.mmd
  • Generate complete FastAPI backend instantly
  • Get production-ready code with validation
  • Auto-generated OpenAPI documentation
  • Built-in authentication and authorization

Implementation Steps

  1. 1
    Write schema.mmd with entities and relationships
  2. 2
    Run s2ai.builder to generate server
  3. 3
    Deploy s2ai.server
  4. 4
    Launch s2ai.face for admin interface
  5. 5
    Integrate s2ai.genius for AI capabilities

Enterprise Applications with Security

Scenario: Building enterprise software that requires complex role-based permissions

Solution: Define users, roles and permissions or connect your own auth services, enforce automatically

Key Benefits

  • s2ai.server automatically enforces permissions at the API level
  • s2ai.face automatically enforces permissions
  • s2ai.genius automatically enforces permissions
  • Centralized permission management

Implementation Steps

  1. 1
    Create Users and Roles with permissions
  2. 2
    Add @service authn and authz annotations
  3. 3
    Generate server with s2ai.builder
  4. 4
    Manage s2ai.auth users, roles and permissions through standard s2ai UI

AI-Powered Applications

Scenario: Integrating AI models with your API for intelligent automation

Solution: Use s2ai.genius MCP server

Key Benefits

  • AI models understand your API through MCP
  • Context-aware AI operations
  • Metadata-driven AI workflows
  • Seamless integration with AI tools
  • Extensible AI capabilities

Implementation Steps

  1. 1
    Build API with schema-driven approach
  2. 2
    Deploy s2ai.server
  3. 3
    Connect s2ai.genius as MCP server
  4. 4
    AI models can now interact with your API
  5. 5
    Build intelligent workflows

API-First Development

Scenario: Multiple frontend teams need consistent APIs with comprehensive testing

Solution: Schema-driven APIs with automatic testing

Key Benefits

  • Schema ensures API consistency
  • Auto-generated OpenAPI spec
  • Built-in validation and RBAC
  • Multiple database support - simultaneous using different DB adapters
  • Fast iteration cycles

Implementation Steps

  1. 1
    Define API contract in schema.mmd
  2. 2
    Generate server and OpenAPI spec
  3. 3
    Deploy s2ai.server with validation
  4. 4
    Frontend teams build against OpenAPI spec
  5. 5
    Update schema to evolve API safely

Ready to Start Your Project?

Whether you're working with an existing database or starting fresh, Schema2AI provides the tools you need to succeed.

Get StartedView Demo