supabase-community/supabase-mcp

Features

• AI Agent Servers - Deploys MCP servers on edge functions to expose integration schemas and actions to AI agents.
• Database-Integrated AI - Connects AI assistants to PostgreSQL databases via the Model Context Protocol to manage schemas and run migrations.
• MCP Protocol Integrations - Implements the Model Context Protocol to provide AI agents with a standardized interface for database management.
• MCP Tool Servers - Provides a serverless implementation of the Model Context Protocol to connect AI assistants to database resources via edge functions.
• Database Management Tools - Links AI assistants to the database via MCP to perform schema management and migrations.
• Database Connectors - Acts as a secure interface that allows AI agents to interact with database schemas and execute queries.
• Model Context Protocol Servers - Implements the Model Context Protocol to expose database capabilities and tools to AI agents.
• Database Branching - Enables the creation of isolated database instances for safe feature development and testing.
• Database Change Listeners - Provides utilities for monitoring and reacting to data modifications within database tables.
• Database Schema Migrations - Automates the application of versioned updates to database schemas to maintain structural consistency.
• Database Query Execution - Allows the execution of raw SQL and migration files to inspect and modify the database schema.
• Database Query Interfaces - Exposes a database query interface that allows AI-compatible tools to execute SQL and manage migrations.
• Database Resource Provisioning - Provides dedicated database and storage resources for persisting application data.
• Realtime Synchronization - Synchronizes data across clients by pushing database updates instantly via WebSockets.
• PostgreSQL Administration Tools - Provides AI-driven tools for managing PostgreSQL database structures, executing SQL queries, and handling migrations.
• Semantic Search - Enables the construction of RAG pipelines and semantic search using vector embeddings.
• SQL Query Execution - Provides a dashboard to execute SQL statements and retrieve results as structured data.
• Vector Indexing - Provides high-dimensional vector indexing with distance metrics to power similarity search.
• Filtered Similarity Searches - Combines vector similarity searches with relational SQL metadata filters to refine results.
• Vector Storage - Implements high-dimensional vector storage alongside relational data to enable hybrid semantic search via SQL.
• Edge Function Runtimes - Runs code in globally distributed edge function runtimes to process requests closer to users.
• Serverless Backend Hosting - Hosts serverless functions in a distributed edge environment to provide low-latency HTTP endpoints and tool execution.
• Serverless Deployment - Executes TypeScript code in a distributed serverless environment to provide HTTP endpoints.
• Serverless Function Management - Manages the deployment and monitoring of serverless edge functions to handle backend logic.
• Broadcast Messaging - Sends ephemeral, real-time data to subscribed clients for immediate communication.
• Database Change Streaming - Pushes real-time database change events and ephemeral messages to connected clients via WebSockets.
• Database Change Streaming - Streams real-time database row and column updates to clients based on specific filters.
• Low Latency Messaging - Implements low-latency messaging for real-time data exchange like cursor tracking.
• Identity-Based Data Restrictions - Implements fine-grained access control to database records integrated with user identity tokens.
• Row Level Security - Enforces fine-grained data access control by linking user identity tokens to SQL-based row-level security policies.
• User Identity Verification - Verifies user identities using passwords, magic links, social logins, and single sign-on methods.
• User Access Management - Provides centralized management of user identities, authorization levels, and access permissions via APIs.
• User Identity Management - Manages the full lifecycle of user identities and authentication to secure application resources.
• Edge Function Deployments - Deploys custom execution code to the edge for low-latency request processing.
• AI Integration Frameworks - Connects to external language model providers and orchestration libraries to extend the capabilities of the data store.
• AI Agent Prompting Instructions - Supplies curated instructions and prompts to AI agents to ensure consistent task execution.
• API Generators - Automates the creation of API endpoints based on existing database schemas to eliminate boilerplate backend code.
• Data Seeding Utilities - Automates the population of test database branches with initial data using seed files.
• Database Extenders - Adds specialized database extensions for vector search, geospatial data, and scheduled tasks.
• Database Migrations - Runs migration scripts to version and evolve the database schema.
• Database-to-REST Interfaces - Automatically generates RESTful interfaces from database schemas to expose data for application use.
• Database Triggers - Executes logic and functions automatically in response to table insertions, updates, or deletions.
• Object Bucket Management - Saves files, datasets, and vector embeddings in S3-compatible object storage buckets.
• Read Replicas - Distributes read traffic across regional replicas to reduce latency and increase throughput.
• Real-time Data Synchronization - Streams database changes and broadcasts low-latency messages to clients using WebSockets for real-time synchronization.
• Spreadsheet-Like Interfaces - Offers a spreadsheet-like visual interface for editing database tables and managing relationships.
• Vector Search - Implements vector search capabilities to retrieve information based on mathematical similarity in high-dimensional spaces.
• Embedding Generation - Generates vector embeddings using serverless models to enable semantic search within the database.
• Vector Embedding Indexes - Allows for the storage of high-dimensional vector embeddings alongside relational data for efficient retrieval.
• Vector Similarity Search - Provides the ability to find similar data vectors using distance metrics for semantic retrieval.
• Branch Management - Manages schema migrations separately from production using version control branch workflows.
• Merge Deployment Automators - Triggers automated workflows to apply database migrations and update functions upon branch merges.
• External Workflow Triggers - Sends HTTP requests to external endpoints automatically when specific database table events occur.
• Serverless Function Executions - Provides a runtime environment for executing serverless functions as backend logic at the edge.
• Preview Environments - Spins off temporary isolated environments with unique credentials to test schemas safely.
• Message Queues - Implements native message queues for asynchronous task processing and background jobs.
• Recurring Job Scheduling - Executes SQL statements or HTTP webhooks on a fixed timetable using cron syntax.
• Environment Branching - Provides isolated database copies synced with version control to test schema changes without affecting production.
• Database Native Queues - Utilizes native PostgreSQL tables to implement asynchronous task processing and guaranteed message delivery.
• Security and Access Control - Implementing authentication and fine-grained row level security to protect application data and files.
• Single Sign-On - Implements SAML 2.0 and multi-factor authentication to provide enterprise-grade single sign-on.
• Background Job Monitoring - Tracks the run history and error details of asynchronous scheduled tasks.
• Function Monitoring - Tracks real-time execution metrics and logs specifically for serverless functions.
• Logging and Telemetry - Gathers logs, metrics, and traces to monitor system health and debug request flows.
• Log Management Services - Centralizes and retrieves diagnostic logs across various service types for troubleshooting.
• Queue Depth Monitoring - Monitors queue depth and message status in real time to ensure observability of task processing.
• Organization Project Management - Provides administrative control over the lifecycle of projects and organizations within a cloud account.
• Schema-Driven API Generators - Automatically generates REST and GraphQL APIs derived directly from the database schema.
• Database Management - Official integration for Supabase project and data management.

Star history