Supabase NextJS MCP Server
The Supabase NextJS MCP Server is a TypeScript-based server that implements a simple notes system while providing tools for Supabase database interaction.
Manage Notes: Create, list, and access text notes via
note://URIs with metadataSummarize Notes: Generate summaries of stored notes using structured prompts
Supabase Operations: Perform complete CRUD operations—query, insert, update, and delete records with optional column selection and filters
Development Tools: Includes build commands and debugging support through MCP Inspector
Installation: Can be installed manually or via Smithery for Claude Desktop integration
Provides tools for database operations in Supabase including querying data, inserting records, updating records, and deleting records, allowing interaction with Supabase tables from a NextJS application.
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Supabase NextJS MCP Servercreate a note titled 'Meeting Notes' with the content 'Discussed project timeline and deliverables'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
supabase-nextjs-server MCP Server
A Model Context Protocol server
This is a TypeScript-based MCP server that implements a simple notes system for NextJS. It demonstrates core MCP concepts by providing:
Resources representing text notes with URIs and metadata
Tools for creating new notes
Prompts for generating summaries of notes
Features
Init
Require
NEXT_PUBLIC_SUPABASE_URLandNEXT_PUBLIC_SUPABASE_ANON_KEYenvironment variables
Resources
List and access notes via
note://URIsEach note has a title, content and metadata
Plain text mime type for simple content access
Tools
create_note- Create new text notesTakes title and content as required parameters
Stores note in server state
Prompts
summarize_notes- Generate a summary of all stored notesIncludes all note contents as embedded resources
Returns structured prompt for LLM summarization
Related MCP server: MCP Server
Development
Install dependencies:
npm installBuild the server:
npm run buildFor development with auto-rebuild:
npm run watchInstallation
To use with Claude Desktop, add the server config:
On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"supabase-nextjs-server": {
"command": "/path/to/supabase-nextjs-server/build/index.js"
}
}
}Installing via Smithery
To install Supabase Notes for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @tengfone/supabase-nextjs-mcp-server --client claudeDebugging
Since MCP servers communicate over stdio, debugging can be challenging. We recommend using the MCP Inspector, which is available as a package script:
npm run inspectorThe Inspector will provide a URL to access debugging tools in your browser.
Available Tools
4 toolsdelete_recordC
Delete a record from Supabase
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| filters | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. While 'Delete' implies a destructive mutation, the description doesn't specify whether this operation is irreversible, what permissions are required, or how errors are handled. It mentions Supabase but doesn't explain authentication or rate limits.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence with zero waste. It's appropriately sized and front-loaded, directly stating the tool's purpose without unnecessary elaboration.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a destructive mutation tool with 2 undocumented parameters, 0% schema coverage, no annotations, and no output schema, the description is inadequate. It doesn't address critical aspects like safety warnings, parameter usage, or expected outcomes, leaving the agent poorly equipped to use this tool correctly.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the description must compensate but fails to do so. It doesn't explain what 'table' and 'filters' parameters mean, their expected formats, or provide examples. For a tool with 2 required parameters and nested objects, this leaves significant gaps in understanding.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('Delete') and resource ('a record from Supabase'), providing a specific verb+resource combination. However, it doesn't distinguish this tool from its sibling 'update_record' in terms of destructive nature or mention that 'query_data' might be a safer alternative for read operations.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided about when to use this tool versus alternatives like 'insert_record' or 'update_record'. The description lacks context about prerequisites, permissions needed, or warnings about irreversible deletion, which is critical for a destructive operation.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
insert_recordC
Insert a record into Supabase
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| data | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden for behavioral disclosure. 'Insert' implies a write/mutation operation, but the description doesn't specify permissions needed, whether the operation is idempotent, what happens on conflicts, or what the response contains. This leaves significant behavioral gaps for a database mutation tool.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise at just 5 words, with zero wasted language. It's front-loaded with the core action and target, making it immediately understandable despite its brevity.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a database mutation tool with 2 parameters, 0% schema coverage, no annotations, and no output schema, the description is inadequate. It doesn't explain what constitutes a valid 'record', how 'data' should be structured, what happens on success/failure, or how this differs from sibling tools.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
With 0% schema description coverage for both parameters, the description provides no information about what 'table' and 'data' mean, their expected formats, or constraints. The description doesn't compensate for the complete lack of parameter documentation in the schema.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('insert') and target resource ('record into Supabase'), making the purpose immediately understandable. However, it doesn't differentiate this tool from its sibling 'update_record' beyond the basic verb difference, missing an opportunity to clarify when to use insert versus update.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives like 'update_record' or 'delete_record'. There's no mention of prerequisites, appropriate contexts, or exclusions, leaving the agent to infer usage from the tool name alone.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
query_dataC
Query data from Supabase
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| select | No | ||
| filters | No |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It states 'Query data' which implies a read operation, but doesn't clarify if it's safe (non-destructive), requires authentication, has rate limits, or what the output looks like (e.g., format, pagination). This leaves significant gaps for a tool with three parameters.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence with zero waste. It's appropriately sized and front-loaded, though this conciseness comes at the cost of detail, making it under-specified rather than verbose.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity (3 parameters, nested objects, no output schema, and no annotations), the description is incomplete. It doesn't cover parameter usage, behavioral traits, or output expectations, leaving the agent with insufficient information to use the tool effectively beyond a basic guess.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the schema provides no parameter details. The description adds no meaning beyond the tool name—it doesn't explain what 'table', 'select', or 'filters' parameters do, their expected formats, or how they interact. For three undocumented parameters, this is inadequate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'Query data from Supabase' states the action (query) and target (Supabase data), which is clear but vague. It doesn't specify what type of query (e.g., SELECT with filters) or distinguish it from siblings like delete_record, insert_record, update_record beyond the generic 'query' verb.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives. The description lacks context on prerequisites, such as when querying is appropriate compared to insert_record or update_record, or any constraints like table permissions or data availability.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
update_recordC
Update a record in Supabase
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| filters | Yes | ||
| data | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries full burden but only states the basic operation. It doesn't disclose behavioral traits like required permissions, whether updates are reversible, rate limits, error handling, or what happens to existing data not mentioned in 'data' parameter. For a mutation tool with zero annotation coverage, this is inadequate.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence with zero wasted words. It's appropriately sized and front-loaded with the core purpose.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
For a 3-parameter mutation tool with no annotations, 0% schema description coverage, and no output schema, the description is incomplete. It doesn't address parameter meanings, behavioral implications, or usage context, leaving significant gaps for agent understanding.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the description must compensate but adds no parameter information. It doesn't explain what 'table', 'filters', or 'data' represent, their expected formats, or how they interact. This leaves all 3 parameters undocumented beyond their schema types.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description clearly states the action ('Update') and target ('a record in Supabase'), providing specific verb+resource. However, it doesn't differentiate from sibling tools like 'insert_record' or 'delete_record' beyond the basic operation type.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided about when to use this tool versus alternatives like 'insert_record' (for new records) or 'delete_record' (for removal). The description lacks context about prerequisites, appropriate scenarios, or exclusions.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
TDQS
Each tool has a clearly distinct purpose targeting a specific CRUD operation: delete, insert, query, and update. There is no overlap or ambiguity between these fundamental database operations, making tool selection straightforward for an agent.
All tool names follow a consistent verb_noun pattern (delete_record, insert_record, query_data, update_record) with perfect uniformity. The naming convention is predictable and readable throughout the set.
With exactly 4 tools covering the core CRUD operations for a database server, this is well-scoped and appropriate. Each tool earns its place with no redundancy or missing essentials for basic data manipulation.
The tool set provides complete CRUD coverage for the Supabase database domain: create (insert), read (query), update, and delete. There are no obvious gaps for basic data operations, ensuring agents can handle full lifecycle workflows without dead ends.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
Google Keep-style notes app with an MCP server for AI agents to read/write notes.
An MCP server that used to create notes
Markdown-based note-taking with a hosted MCP server. Your notes serve you and your AI.
MCP server for generating rough-draft project plans from natural-language prompts.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceThis TypeScript-based server implements a simple notes system, allowing users to create and manage text notes and generate summaries, showcasing core MCP concepts.2016Apache 2.0
- AlicenseNot gradedqualityDmaintenanceThis TypeScript-based MCP server allows users to manage a simple notes system through creating and summarizing text notes using Model Context Protocol (MCP).2,0138MIT
- FlicenseNot gradedqualityDmaintenanceA TypeScript-based MCP server that enables users to manage text notes with features like note creation and summary generation using a Model Context Protocol.1
- AlicenseBqualityDmaintenanceA TypeScript-based MCP server that implements a simple notes system, allowing users to create, access, and generate summaries of text notes.121,0283MIT
Appeared in Searches
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/tengfone/supabase-nextjs-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server