Provides essential database operations including data selection and mutation, file storage management, and user authentication through a minimal set of 4 tools optimized for reduced context usage.
Supabase MCP Lite
Minimal Supabase MCP server - 70% less context usage than standard implementations.
Why Lite?
- 4 tools instead of 50+ - Only essential operations
- Minimal descriptions - No verbose explanations
- Simple parameters - No complex nested schemas
- Auto-truncated results - Max 100 rows per query
🔑 Personal Access Token Required
This MCP uses your Supabase Personal Access Token (starts with sbp_
) to automatically fetch service role keys for any project you own.
How to get your Personal Access Token:
- Go to https://supabase.com/dashboard/account/tokens
- Click "Generate New Token"
- Give it a name (e.g., "MCP Access")
- Copy the token (starts with
sbp_
) - Save it securely - you won't be able to see it again!
Setup
- Add to your MCP client configuration:
Note: Project URL is required for each tool call. The service role key will be fetched automatically using your access token.
Tools (4)
All tools require projectUrl
as the first parameter.
Tool | Purpose | Parameters |
---|---|---|
select | Get data | projectUrl, table, where?, limit? |
mutate | Change data | projectUrl, action, table, data?, where? |
storage | Files | projectUrl, action, bucket, path?, data? |
auth | Users | projectUrl, action, email?, password?, id? |
Examples
How it Works
- You provide your Personal Access Token (
sbp_xxx
) - When you call a tool with a project URL, the MCP:
- Extracts the project ID from the URL
- Uses your access token to fetch the service role key via Supabase Management API
- Caches the key for future requests to the same project
- Creates a client with full admin access
Security Notes
- Personal Access Token gives access to ALL your Supabase projects
- Service role keys are fetched automatically and cached in memory
- Service role key bypasses Row Level Security (RLS)
- Keep your access token secure - never expose it client-side
- This tool is intended for server-side/admin use only
Features
- ✅ Works with any Supabase project you own
- ✅ Automatic service role key retrieval
- ✅ Key caching to minimize API calls
- ✅ Full database access (bypasses RLS)
- ✅ Support for multiple projects in one session
License
MIT
This server cannot be installed
remote-capable server
The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.
Enables minimal interaction with Supabase databases through 4 essential tools for data querying, mutations, file storage, and user authentication. Designed for 70% less context usage than standard implementations with auto-truncated results and simplified parameters.