SchemaFlow

What is SchemaFlow MCP Server?

SchemaFlow MCP Server provides real-time access to PostgreSQL and Supabase database schemas for AI-IDEs (like Cursor, Windsurf, and VS Code + Cline) through the Model Context Protocol (MCP). This allows AI assistants to query schema data in real-time for improved code generation and database interaction.

How to use SchemaFlow MCP Server?

1. Get Your MCP Token: Visit the SchemaFlow Dashboard (schemaflow.dev/dashboard) to connect your database, load/cache your schema, and generate an MCP token.
2. Configure Your AI-IDE: Add the SchemaFlow MCP server configuration to your AI-IDE (Cursor, Windsurf, or VS Code + Cline) using the provided JSON snippets, including your generated token.

Key Features of SchemaFlow MCP Server

• Real-time Schema Access: Provides live database context to AI-IDEs.
• Secure SSE Connections: Utilizes secure Server-Sent Events for communication.
• get_schema Tool: Retrieves comprehensive database schema information (tables, columns, relationships, functions, triggers, enums, indexes).
• analyze_database Tool: Performs database analysis for performance insights, security assessment, and structural recommendations.
• check_schema_alignment Tool: Validates schema against best practices and identifies potential issues.
• Schema Caching: Automatically caches schemas for quick MCP access.
• Token-based Authentication: Ensures secure and user-specific access.
• Encrypted Connections: All MCP communication is encrypted.
• Schema Metadata Only: No actual data is accessed or stored.

Use Cases of SchemaFlow MCP Server

• Smarter Code Generation: AI-IDEs can generate more accurate and context-aware code based on live schema information.
• Database Analysis: AI assistants can perform performance, security, and structural analysis of PostgreSQL and Supabase databases.
• Schema Validation: Identify and resolve schema issues by checking against best practices.
• Interactive Database Exploration: Part of the larger SchemaFlow platform that offers schema visualization, multi-format export, and a schema browser.

FAQ about SchemaFlow MCP Server

• Does SchemaFlow access my actual database data? No, SchemaFlow only accesses and stores schema metadata, not your actual data.
• How secure is the connection? Connections are token-based, encrypted, and user-specific, ensuring secure access to your cached schema data.
• What AI-IDEs are supported? Currently, Cursor, Windsurf, and VS Code + Cline are supported.
• Where can I find more documentation? Detailed setup instructions and troubleshooting can be found in the Complete MCP Integration Guide at schemaflow.dev/mcp-guide.

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

• Documentation: schemaflow.dev/mcp-guide
• Dashboard: schemaflow.dev/dashboard
• Issues: Create an issue in this repository

📄 License

MIT License - see LICENSE file for details.