Airis Supabase Selfhost

[!WARNING] Unmaintained / archived. This repository is no longer developed or supported, and is archived read-only. It is left published for reference only. Released under the MIT License, so you are free to fork it, but expect no updates, issue responses, or security fixes.

MCP (Model Context Protocol) server for self-hosted Supabase with RLS-aware PostgreSQL + PostgREST layers.

---

🌟 Part of the AIRIS Ecosystem

This MCP server is designed to work with the AIRIS Suite - accessible via airis-mcp-gateway for token-efficient integration. See the full AIRIS Suite on the org page.

MCP Servers (Included via Gateway)

• airis-mcp-supabase-selfhost (this repo) - Self-hosted Supabase MCP with RLS support
• mindbase - Memory search & storage tools (mindbase_search, mindbase_store)

Recommended: Install via AIRIS MCP Gateway

This MCP server comes pre-configured with AIRIS MCP Gateway. No additional setup required.

# Install the Gateway (includes this server)
brew install agiletec-inc/tap/airis-mcp-gateway

# Start the gateway
airis-mcp-gateway up

# Add to Claude Code
claude mcp add --transport http airis-mcp-gateway http://api.gateway.localhost:9400/api/v1/mcp

Alternative: Standalone Installation

If you need to run this server independently:

git clone https://github.com/agiletec-inc/airis-mcp-supabase-selfhost.git
cd airis-mcp-supabase-selfhost && pnpm install

What you get with the full suite:

• ✅ Confidence-gated workflows (prevents wrong-direction coding)
• ✅ Deep research with evidence synthesis
• ✅ 94% token reduction via repository indexing
• ✅ Cross-session memory across all editors
• ✅ Self-review and post-implementation validation

---

✨ Features

• 2-Layer Backend: PostgREST (RLS-respected) + Direct PostgreSQL (schema introspection & diagnostics)
• Token-Optimized: Lazy advertise, schema digest, minimal tool descriptions
• Safety-First: READ_ONLY mode by default, DML/DDL/DCL blocked, SQL validation
• Feature Flags: Selective tool activation (database, docs, postgrest, functions, storage)
• RLS Awareness: PostgREST layer respects Row Level Security policies
• Supabase Compatible: Works with official Supabase self-hosted deployments

🏗️ Architecture

┌─────────────────────────────────────────┐
│  LLM (Claude, GPT, etc.)               │
└───────────────┬─────────────────────────┘
                │ MCP Protocol (JSON-RPC)
┌───────────────▼─────────────────────────┐
│  Supabase Self-hosted MCP Server       │
│  ┌─────────────────────────────────┐   │
│  │  Feature Flags & Safety Guards  │   │
│  └─────────────────────────────────┘   │
│         │                    │          │
│  ┌──────▼──────┐      ┌─────▼──────┐   │
│  │  PostgREST  │      │   Direct   │   │
│  │   Layer     │      │    PG      │   │
│  │ (RLS aware) │      │ (read-only)│   │
│  └──────┬──────┘      └─────┬──────┘   │
└─────────┼──────────────────┼───────────┘
          │                  │
          ▼                  ▼
    ┌─────────────────────────────┐
    │   Supabase Self-hosted      │
    │   (PostgreSQL + PostgREST)  │
    └─────────────────────────────┘

🚀 Quick Start

Prerequisites

• Node.js >= 20.0.0
• Self-hosted Supabase instance running (localhost:54321 or remote)
• PostgreSQL read-only user (recommended)

1. Install Dependencies

pnpm install

2. Configure Environment

cp .env.example .env
# Edit .env with your Supabase credentials

Key Configuration:

# PostgreSQL (use read-only role for safety)
PG_DSN=postgres://mcp_ro:[email protected]:5432/postgres

# PostgREST endpoint
POSTGREST_URL=http://127.0.0.1:54321/rest/v1

# PostgREST JWT (anon key or service_role key)
POSTGREST_JWT=your_anon_key_here

# Safety mode (recommended: true)
READ_ONLY=true

# Feature flags
FEATURES=database,docs,postgrest

3. Create Read-Only PostgreSQL User (Recommended)

-- Connect to your Supabase PostgreSQL as superuser
CREATE ROLE mcp_ro WITH LOGIN PASSWORD 'secure_password';
GRANT pg_read_all_data TO mcp_ro;
GRANT USAGE ON SCHEMA public TO mcp_ro;
GRANT USAGE ON SCHEMA information_schema TO mcp_ro;

4. Start Server

# Development mode (with auto-reload)
pnpm dev

# Production mode
pnpm build
pnpm start

Server starts on http://localhost:3100

🛠️ Available Tools

MVP Tools (Current Implementation)

Tool Prefix: All tools use sbsh_ prefix to avoid collision with official Supabase MCP and PostgreSQL MCP servers.

1. sbsh_introspect_schema

Get token-optimized schema summary for specified schemas.

{
  "name": "sbsh_introspect_schema",
  "arguments": {
    "schemas": ["public"]
  }
}

Output: Digest format with table names, column types, index/constraint counts, RLS status.

2. sbsh_execute_sql

Execute SELECT queries or EXPLAIN plans safely.

{
  "name": "sbsh_execute_sql",
  "arguments": {
    "sql": "SELECT * FROM users WHERE created_at > '2024-01-01' LIMIT 10",
    "limit": 100
  }
}

Safety: In READ_ONLY mode, DML/DDL/DCL are blocked.

3. sbsh_postgrest_get

GET request via PostgREST with RLS respected.

{
  "name": "sbsh_postgrest_get",
  "arguments": {
    "table": "users",
    "query": {
      "select": "id,email,created_at",
      "eq": "status:active",
      "order": "created_at.desc",
      "limit": 10
    }
  }
}

Security: Uses provided JWT, respects RLS policies.

4. sbsh_get_table_doc

Get detailed documentation for a specific table.

{
  "name": "sbsh_get_table_doc",
  "arguments": {
    "table": "public.users"
  }
}

Output: Columns, constraints, RLS policies, comments.

🔐 Security Features

READ_ONLY Mode (Default)

• Enabled by default for safety
• Blocks all DML/DDL/DCL operations
• Only allows SELECT and EXPLAIN queries
• Recommended for production use

SQL Validation

• Regex-based detection of mutating operations
• Blocks: INSERT, UPDATE, DELETE, TRUNCATE, ALTER, DROP, CREATE, GRANT, REVOKE, etc.
• Allows: SELECT, EXPLAIN

RLS Respect

• PostgREST layer automatically enforces Row Level Security
• Direct PostgreSQL layer uses read-only role (no write permissions)
• JWT-based authentication for user-scoped access

Feature Flags

Control tool availability via FEATURES environment variable:

• database: Schema introspection and SQL execution
• docs: Table documentation
• postgrest: PostgREST API wrapper
• functions: Edge Functions (not yet implemented)
• storage: Storage API (not yet implemented)

📊 Token Optimization

Lazy Advertise

• Only advertise enabled features
• Minimal tool descriptions (detailed help on demand)
• Feature flags reduce initial token load

Schema Digest

• introspect_schema returns compressed summary
• Full details via docs.get_table_doc on demand
• Column format: name:type! (! = NOT NULL)

Result Sampling

• Configurable row limits (max 1000)
• Field metadata included for context
• Truncation warnings

🔧 Development Roadmap

Phase 1: MVP (Current)

• Project setup
• Core tools: introspect_schema, execute_sql, postgrest.get, docs
• READ_ONLY mode
• Feature flags
• Token optimization

Phase 2: Enhanced Safety

• Dry-run mode for DML operations
• Audit logging
• Rate limiting
• Query cost estimation

Phase 3: Extended Features

• Edge Functions support
• Storage API integration
• Real-time subscriptions
• Multi-project support

Phase 4: Advanced Optimization

• Schema caching with invalidation
• Result pagination
• Streaming responses
• Connection pooling optimization

🤝 Integration

With airis-mcp-gateway

This server is designed to work with dynamic MCP gateway patterns:

// Load only when Supabase tools are needed
await gateway.loadServer('airis-mcp-supabase-selfhost', {
  url: 'http://localhost:3100/mcp',
  features: 'database,docs'
})

// Use tools
await gateway.call('airis-mcp-supabase-selfhost', 'sbsh_introspect_schema', {})

// Unload after use
await gateway.unloadServer('airis-mcp-supabase-selfhost')

With Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "airis-mcp-supabase-selfhost": {
      "command": "node",
      "args": ["/path/to/dist/server.js"],
      "env": {
        "PG_DSN": "postgres://mcp_ro:pass@localhost:5432/postgres",
        "POSTGREST_URL": "http://localhost:54321/rest/v1",
        "POSTGREST_JWT": "your_jwt_here",
        "READ_ONLY": "true",
        "FEATURES": "database,docs,postgrest"
      }
    }
  }
}

---

🔗 Related Projects

Explore other tools in the AIRIS ecosystem:

• airis-mcp-gateway - Unified MCP hub with 90% token reduction
• airis-agent - Intelligence layer for AI coding
• mindbase - Local cross-session memory with semantic search
• airis-workspace - Docker-first monorepo manager
• cmd-ime - macOS IME switcher
• neural - Local LLM translation tool
• airiscode - Terminal-first autonomous coding agent

---

🤝 Contributing

We welcome contributions! Please:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'feat: add amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

---

📝 License

MIT

---

🙏 Acknowledgments

• Inspired by Supabase official MCP
• Built on Model Context Protocol
• PostgreSQL introspection patterns from community MCP servers

💖 Support

agiletec is a one-person studio building these tools full-time and open source. If they earn a spot in your workflow, a sponsorship keeps them maintained and independent.

Sponsor agiletec

---

Built with ❤️ by the Agiletec team

Agiletec Inc. | Documentation | Issues | Discussions