SchemaFlow

by CryptoRadi

325 downloads

Not rated

GitHub

About

Real-time PostgreSQL & Supabase database schema access for AI-IDEs via Model Context Protocol. Provides live database context through secure SSE connections with three powerful tools: get_schema, analyze_database, and check_schema_alignment. [SchemaFlow](https://schemaflow.dev)

Details

Author: CryptoRadi
Downloads: 325
Categories: Database, Community, Other

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below

Plugin Name SchemaFlow

Command (node, npx, python, etc.)

Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

JSON

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

From the repository

Visit the SchemaFlow Dashboard at https://schemaflow.dev/dashboard, connect your PostgreSQL or Supabase database, generate an MCP token, then configure your AI-IDE (Cursor, Windsurf, or VS Code + Cline) with the SSE endpoint and token.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "schemaflow": {
            "schemaflow": {
                "type": "sse",
                "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
                "description": "Real-time PostgreSQL/Supabase schema access"
            }
        }
    }
}

McpServers

{
    "schemaflow": {
        "type": "sse",
        "url": "https://api.schemaflow.dev/mcp/?token=<YOUR_TOKEN>",
        "description": "Real-time PostgreSQL/Supabase schema access"
    }
}

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.

- Connect your PostgreSQL or Supabase database
- Load and cache your schema
- Generate an MCP token
- Open Cursor Settings
- Go to Features → MCP
- Click "Add New MCP Server"
- Use this configuration:

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

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

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

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

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

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

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

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

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

- "Check schema alignment"
- "Validate my database"
- "Any schema issues?"
- "Check naming conventions"
- Schema Caching: When you load your schema in SchemaFlow dashboard, it's automatically cached for MCP access
- Secure Connection: Your AI-IDE connects using MCP with secure token authentication
- Real-time Access: Your AI assistant can query schema data in real-time for better code generation

- 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

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

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

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

MIT License - see LICENSE file for details.

Read and write access to Airtable databases.

BigQuery database integration with schema inspection and query capabilities

Server implementation for Google BigQuery integration that enables direct BigQuery database access and querying capabilities

A MCP server that provides real-time cryptocurrency market data through CoinCap's public API without requiring authentication

Universal database MCP server supporting multiple database types including PostgreSQL, Redshift, CockroachDB, MySQL, RDS MySQL, Microsoft SQL Server, BigQuery, Oracle DB, and SQLite

MCP server for autonomous data exploration on .csv-based datasets, providing intelligent insights with minimal effort.

Universal database MCP server supporting mainstream databases.

MCP server for dbt-core (OSS) users as the official dbt MCP only supports dbt Cloud. Supports project metadata, model and column-level lineage and dbt documentation.

Leverages your Schemas and Access Patterns to interact with your DynamoDB Database using natural language.

MCP server acting as an interface to the Frankfurter API for currency exchange data.

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

SchemaFlow

About

Details

Jump to

Setting up with Highlight

Setting up with Cursor

JSON

JSON

JSON

Setting up with Claude Desktop

JSON

JSON

JSON

Setting up with Windsurf

JSON

JSON

JSON

Setting up with Cline

JSON

JSON

JSON

Setting up with Goose

JSON

JSON

JSON

From the repository

Claude Desktop / Cursor

McpServers

Install

About

Details

Jump to

Setting up with Highlight

From the repository

Claude Desktop / Cursor

McpServers

Install

More like this

Sequential Thinking

Redis

Filesystem

EverArt

Google Drive

Sqlite