SupaMCP Server

SupaMCP Server is an MCP server that converts any Supabase project into an AI-compatible tool interface via declarative JSON definitions. It connects directly to Supabase PostgREST endpoints using an anon key and user credentials, eliminating the need to write backend code for each individual tool. Developers and database administrators use this server to expose custom database operations—including select, insert, update, and delete actions—to AI clients like Cursor and Claude Desktop. By handling user-level authentication with automatic JWT token refresh, the server ensures all actions execute under Supabase Row Level Security (RLS) policies. Configurations can be supplied as local JSON files, inline command-line arguments, or Base64-encoded strings, supporting Jinja2-style dynamic templating for parameterized queries. This setup enables AI agents to query structured data, generate complex relational records, and update records safely within user-defined permission boundaries.

Category: Cloud & Infrastructure

Tags: backend, database, postgresql, supabase

Visit SupaMCP Server

How to install and configure SupaMCP Server

1. Install the server globally using npm: bash npm install -g supamcpbuilder Alternatively, run it directly with npx -y supamcpbuilder. 2. Create a JSON tool configuration file (e.g., tools-config.json) defining your custom database actions such as select, insert, update, or delete. 3. Register the server in Claude Desktop by editing your configuration file: json { "mcpServers": { "supamcpbuilder": { "command": "npx", "args": [ "-y", "supamcpbuilder", "--url", "https://your-project.supabase.co", "--anon-key", "your-anon-key", "--email", "your-email@example.com", "--password", "your-password", "--config-path", "/path/to/your/tools-config.json" ] } } } For Cursor IDE, configure ~/.cursor/mcp.json using the same arguments or pass --tools-json-base64 with your Base64-encoded tool schema.

What you can do with SupaMCP Server

• Query Supabase tables directly from Claude Desktop using parameterized filters and select statements configured via JSON. - Create multi-attribute records and user profiles using insert action templates that automatically return newly generated identifiers. - Modify existing database records securely by enforcing user authentication and existing Supabase Row Level Security policies. - Delete obsolete rows from designated tables without deploying custom backend API endpoints or writing custom server logic. - Integrate dynamic database lookup actions into Cursor IDE using Base64-encoded configuration strings within the editor settings.

Key facts

• Open Source
• https://github.com/vivek100/supaMCPBuilder
• Cloud & Infrastructure, Databases & Data Stores
• backend, database, postgresql, supabase

Part of MCP Servers

How do I install SupaMCP Server?

You can install SupaMCP Server globally by running npm install -g supamcpbuilder. You can also run it without installation using npx supamcpbuilder directly in your terminal or inside your MCP client configuration.

Which MCP clients work with SupaMCP Server?

SupaMCP Server works with any standard Model Context Protocol client. The official documentation provides explicit configuration examples for Claude Desktop and Cursor IDE using JSON configuration files or Base64-encoded configuration arguments.

What database actions can SupaMCP Server perform?

SupaMCP Server supports four primary database operations defined through JSON schemas: select to query records, insert to create new rows, update to modify existing data, and delete to remove table entries.

How does SupaMCP Server handle security and permissions?

SupaMCP Server relies on Supabase email and password authentication with automated JWT token refresh. Because it operates with user credentials rather than admin or service role keys, all database operations respect your Supabase Row Level Security policies.

Is SupaMCP Server open source?

Yes, SupaMCP Server is an open source project distributed under the MIT License on GitHub.