Skip to main content
Glama

SchemaFlow MCP Server

by CryptoRadi
MIT License

SchemaFlow MCP Server

Real-time PostgreSQL & Supabase schema access for AI-IDEs via Model Context Protocol (MCP)

SchemaFlow MCP Server provides your AI-IDE with live access to PostgreSQL and Supabase database schemas through the Model Context Protocol. Get real-time schema context for smarter code generation in tools like Cursor, Windsurf, and VS Code + Cline.

🚀 Quick Start

Visit SchemaFlow →

1. Get Your MCP Token

Visit SchemaFlow Dashboard to:

  • Connect your PostgreSQL or Supabase database
  • Load and cache your schema
  • Generate an MCP token

2. Configure Your AI-IDE

For Cursor IDE:
  1. Open Cursor Settings
  2. Go to Features → MCP
  3. Click "Add New MCP Server"
  4. Use this configuration:
{ "name": "schemaflow", "type": "sse", "url": "https://api.schemaflow.dev/mcp/?token=your-token-here" }
For Windsurf IDE:

Add to your MCP configuration:

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

Configure in Cline's MCP settings:

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

🛠️ Available MCP Tools

get_schema

Retrieves complete database schema information including tables, columns, relationships, functions, triggers, enums, and indexes from PostgreSQL or Supabase databases.

Parameters:

  • query_type (optional): Filter specific information (tables, columns, relationships, functions, triggers, enums, indexes, all)

Example AI queries:

  • "Show me my database schema"
  • "What tables do I have?"
  • "Show me all relationships"
  • "List database functions"

analyze_database

Performs comprehensive database analysis including performance insights, security assessment, and structural recommendations for PostgreSQL and Supabase databases.

Example AI queries:

  • "Analyze my database performance"
  • "Check database security"
  • "Review database structure"
  • "Give me a database overview"

check_schema_alignment

Validates your PostgreSQL or Supabase schema against best practices and identifies potential issues with actionable recommendations.

Example AI queries:

  • "Check schema alignment"
  • "Validate my database"
  • "Any schema issues?"
  • "Check naming conventions"

🔧 How It Works

  1. Schema Caching: When you load your schema in SchemaFlow dashboard, it's automatically cached for MCP access
  2. Secure Connection: Your AI-IDE connects using MCP with secure token authentication
  3. Real-time Access: Your AI assistant can query schema data in real-time for better code generation

🔒 Security

  • Schema metadata only - No actual data is accessed or stored
  • Token-based authentication - Each user has a unique, revokable token
  • Encrypted connections - All MCP communication is encrypted
  • User-specific access - Tokens only access your own cached schema data

📚 Complete Documentation

For detailed setup instructions, troubleshooting, and advanced configuration, visit:

Complete MCP Integration Guide

🌐 SchemaFlow Platform

This MCP server is part of the larger SchemaFlow platform which also provides:

  • Interactive Schema Visualization - Explore your PostgreSQL/Supabase database structure through intuitive diagrams
  • Multi-Format Export - Export schemas in JSON, Markdown, SQL, and Mermaid formats
  • Schema Browser - Navigate through tables, relationships, and database components
  • Performance Analysis - Get insights into your database structure and optimization opportunities
  • Supabase Integration - Native support for Supabase projects with direct connection

Visit SchemaFlow →

🆘 Support

📄 License

MIT License - see LICENSE file for details.

-
security - not tested
A
license - permissive license
-
quality - not tested

Provides AI-IDEs with real-time access to PostgreSQL and Supabase database schemas through the Model Context Protocol, enabling smarter code generation in tools like Cursor, Windsurf, and VS Code + Cline.

  1. 🚀 Quick Start
    1. Get Your MCP Token
    2. Configure Your AI-IDE
  2. 🛠️ Available MCP Tools
    1. get_schema
    2. analyze_database
    3. check_schema_alignment
  3. 🔧 How It Works
    1. 🔒 Security
      1. 📚 Complete Documentation
        1. 🌐 SchemaFlow Platform
          1. 🆘 Support
            1. 📄 License

              Related MCP Servers

              • A
                security
                A
                license
                A
                quality
                This server enables interaction with Supabase PostgreSQL databases through the MCP protocol, allowing seamless integration with Cursor and Windsurf IDEs for secure and validated database management.
                Last updated -
                11
                699
                Python
                Apache 2.0
                • Apple
                • Linux
              • -
                security
                F
                license
                -
                quality
                A Model Context Protocol server that enables AI assistants to explore and interact with Cursor IDE's SQLite databases, providing access to project data, chat history, and composer information.
                Last updated -
                10
                Python
                • Apple
              • A
                security
                F
                license
                A
                quality
                Enables querying Supabase databases and generating TypeScript types through the Model Context Protocol interface, supporting features like schema selection, column filtering, and pagination.
                Last updated -
                2
                9
                JavaScript
                • Apple
                • Linux
              • A
                security
                A
                license
                A
                quality
                Enables AI models to interact with PostgreSQL databases through a standardized interface, supporting operations like queries, table manipulation, and schema inspection.
                Last updated -
                5
                127
                2
                JavaScript
                MIT License

              View all related MCP servers

              MCP directory API

              We provide all the information about MCP servers via our MCP API.

              curl -X GET 'https://glama.ai/api/mcp/v1/servers/CryptoRadi/schemaflow-mcp-server'

              If you have feedback or need assistance with the MCP directory API, please join our Discord server