Supabase MCP Server
An MCP server that connects to Supabase PostgreSQL databases, exposing table schemas as resources and providing tools for data analysis through SQL queries.
stefanraath3
README
Supabase MCP Server
An MCP server that connects to a Supabase PostgreSQL database, exposing table schemas as resources and providing tools for data analysis.
Features
- Connection to Supabase PostgreSQL database
- Table schemas exposed as resources
- Read-only SQL query tools
- Prompts for common data analysis tasks
Setup
- Clone this repository
- Install dependencies:
npm install - Copy
.env.exampleto.envand update with your Supabase credentials:cp .env.example .env - Edit the
.envfile with your actual Supabase connection details
Running the Server
Using stdio (command line integration)
npm start
Using HTTP with SSE (for web integration)
npm run start:http
Using with MCP Clients
This server can be used with any MCP-compatible client, including Claude.app and the MCP Inspector for testing.
Available Resources
schema://tables- Lists all tables in the databaseschema://table/{tableName}- Shows schema for a specific table
Available Tools
query- Runs a read-only SQL query against the databaseanalyze-table- Gets basic statistics about a tablefind-related-tables- Discovers tables related to a given table
Available Prompts
table-exploration- Guides exploration of a specific tabledata-summary- Creates a summary of data in a tablerelationship-analysis- Analyzes relationships between tables
Recommended Servers
Claude Code MCP
An implementation of Claude Code as a Model Context Protocol server that enables using Claude's software engineering capabilities (code generation, editing, reviewing, and file operations) through the standardized MCP interface.
Metabase MCP Server
Enables AI assistants to interact with Metabase databases and dashboards, allowing users to list and execute queries, access data visualizations, and interact with database resources through natural language.
mixpanel
Connect to your Mixpanel data. Query events, retention, and funnel data from Mixpanel analytics.
Linear MCP Server
A Model Context Protocol server that integrates with Linear's issue tracking system, allowing LLMs to create, update, search, and comment on Linear issues through natural language interactions.
Airtable MCP Server
A Model Context Protocol server that provides tools for programmatically managing Airtable bases, tables, fields, and records through Claude Desktop or other MCP clients.
Sequential Thinking MCP Server
This server facilitates structured problem-solving by breaking down complex issues into sequential steps, supporting revisions, and enabling multiple solution paths through full MCP integration.
mcp-shodan
MCP server for querying the Shodan API and Shodan CVEDB. This server provides tools for IP lookups, device searches, DNS lookups, vulnerability queries, CPE lookups, and more.
@kazuph/mcp-gmail-gas
Model Context Protocol server for Gmail integration. This allows Claude Desktop (or any MCP client) to interact with your Gmail account through Google Apps Script.
MCP PubMed Search
Server to search PubMed (PubMed is a free, online database that allows users to search for biomedical and life sciences literature). I have created on a day MCP came out but was on vacation, I saw someone post similar server in your DB, but figured to post mine.
MCP DuckDB Knowledge Graph Memory Server
A memory server for Claude that stores and retrieves knowledge graph data in DuckDB, enhancing performance and query capabilities for conversations with persistent user information.