Database · Developer Tools

PostgreSQL MCP logo

PostgreSQL MCP

tobecrazy/postgresql-mcp

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.

Install

See repository

Setup steps are in the repository README.

Open README
Category
Database, Developer Tools
License
MIT
Updated
Oct 6, 2026

About PostgreSQL MCP

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

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

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 logo

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 logo

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 logo

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 logo

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 logo

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.

Database