Real-time access to PostgreSQL and Supabase database schemas for AI-IDE via Model Context Protocol. Provides live database context through secure SSE connections for smarter code generation.

Configuration

Cursor IDE

{
  "name": "schemaflow",
  "type": "sse",
  "url": "https://api.schemaflow.dev/mcp/?token=your-token-here"
}

Windsurf IDE

{
  "mcpServers": {
    "schemaflow": {
      "type": "sse",
      "url": "https://api.schemaflow.dev/mcp/?token=your-token-here"
    }
  }
}

VS Code + Cline

{
  "mcpServers": {
    "schemaflow": {
      "type": "sse", 
      "url": "https://api.schemaflow.dev/mcp/?token=your-token-here"
    }
  }
}

Available Tools

Tool	Description
get_schema	Retrieves complete database schema information, including tables, columns, relationships, functions...
analyze_database	Performs comprehensive database analysis, including performance analysis, security assessment, and...
check_schema_alignment	Validates your PostgreSQL or Supabase schema against best practices and identifies potential issues...

Features

• Real-time PostgreSQL and Supabase schema access
• Schema caching for performance
• Secure token-based authentication
• Interactive schema visualization
• Export in multiple formats (JSON, Markdown, SQL, Mermaid)
• Performance analysis and optimization recommendations
• Native Supabase integration
• Schema validation against best practices

Usage Examples

Show me my database schema

What tables do I have?

Show me all relationships

List database functions

Analyze my database performance

Notes

Requires visiting the SchemaFlow Dashboard to connect your database, cache the schema, and generate an MCP token. Only schema metadata is used—actual data is never read or stored. Part of the larger SchemaFlow platform with additional visualization and export capabilities.