How do I configure the Self-Hosted Supabase MCP Server?

Configuration details are provided via command-line arguments or environment variables, including your Supabase URL, anon key, service key (optional), and database URL (optional but recommended).

Which IDEs are compatible with this tool?

This server is designed to be used with MCP client applications like Cursor and Visual Studio Code, enabling database management directly within your IDE.

What is Self-Hosted Supabase MCP Server?

It's a Model Context Protocol (MCP) server that enables database introspection, management, and interaction with your self-hosted Supabase instances from development environments.

What features does it offer?

It includes tools for schema and migration management, database operations, project configuration, TypeScript type generation, and authentication user management. It also helps with Supabase Storage and Realtime Inspection.

What are the prerequisites for using this tool?

You need Node.js (18.x or later), npm, and access to your self-hosted Supabase instance (URL, keys, and potentially a direct DB connection string).

Self-Hosted Supabase

Name: Self-Hosted Supabase
Author: HenkDz

byHenkDz

•

120

•

Cloud Infrastructure

Database Management

Developer Tools

Enables database introspection, management, and interaction with self-hosted Supabase instances from development environments using the Model Context Protocol.

Self-Hosted Supabase

byHenkDz

•

120

•

Cloud Infrastructure

Database Management

Developer Tools

Enables database introspection, management, and interaction with self-hosted Supabase instances from development environments using the Model Context Protocol.

Self-Hosted Supabase bridges the gap between MCP clients and local Supabase projects, empowering developers to interact with their databases directly from their development environment. This server, built from scratch with insights from the official Supabase cloud MCP server, offers a streamlined experience tailored for single-project, self-hosted environments. It provides a suite of tools for querying schemas, managing migrations, inspecting statistics, handling authentication, and interacting with Supabase Storage, ensuring seamless integration with MCP-based tools.

Key Features

01Facilitates authentication user management with tools for listing, creating, deleting, and updating users.

02Provides schema and migration management tools for listing tables, extensions, and applying migrations.

03Includes development tools for generating TypeScript types from the database schema and rebuilding hooks.

04Offers database operations and statistics tools to execute SQL queries and retrieve database connection information.

05Enables project configuration and key retrieval for Supabase URLs, anon keys, and service keys.

0610 GitHub stars

Use Cases

01Generating TypeScript types from the database schema to improve development workflow.

02Managing database schemas and migrations in a self-hosted Supabase environment.

03Inspecting database statistics and connections for performance monitoring.