A Model Context Protocol (MCP) server that provides CRUD operations for PostgreSQL database tables. This MCP server allows you to interact with PostgreSQL databases through a set of tools that provide Create, Read, Update, and Delete (CRUD) operations on specified tables.
A Model Context Protocol (MCP) server that provides CRUD operations for PostgreSQL database tables.
This MCP server allows you to interact with PostgreSQL databases through a set of tools that provide Create, Read, Update, and Delete (CRUD) operations on specified tables. The server uses the FastMCP library and runs in stdio mode, making it compatible with various MCP clients.
Features
Connect to PostgreSQL databases
Perform CRUD operations on specified tables
Table and column-level access control
Schema inspection
Custom SQL query execution
Configuration via YAML file
Tools (7)
list_tables
Lists all tables available in the configuration.
create_record
Creates a new record in the specified table.
read_records
Reads records from the specified table with optional filtering.
update_record
Updates a record in the specified table.
delete_record
Deletes a record from the specified table.
execute_query
Executes a custom SQL query.
get_table_schema
Gets the schema information for a specific table.
Details on this page are taken from the project's README. Open README
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
Database
Genai Toolbox
googleapis/genai-toolbox
769
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
Database
Supabase MCP Server
alexander-zuev/supabase-mcp-server
677
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
Database
Awesome MCP List
MobinX/awesome-mcp-list
645
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
Database
PostgreSQL Model Context Protocol (PG MCP) Server
stuzero/pg-mcp-server
440
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
Database
dbhub
bytebase/dbhub
332
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.