mcp-sql-server

atarkowska/mcp-sql-server

3.2

If you are the rightful owner of mcp-sql-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.

A Model Context Protocol (MCP) server implementation for PostgreSQL databases, providing AI assistants with secure and structured access to PostgreSQL databases.

Tools

Functions exposed to the LLM to take actions

list_tables

Lists all tables in a specified database schema.

get_table_schema

Retrieves detailed schema information for a specific table.

execute_safe_query

Executes read-only SELECT queries safely.

execute_query

Executes any SQL query (SELECT, INSERT, UPDATE, DELETE) with optional parameterization.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources