mcp-server-postgres

luanvuhlu/mcp-server-postgres

3.1

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

A Model Context Protocol (MCP) server for PostgreSQL built with Spring Boot and Spring AI, providing read-only access to PostgreSQL databases through dynamic connections.

Tools

Functions exposed to the LLM to take actions

list_schemas

List all schemas in a database.

list_tables

List all tables in a specific schema.

select

Select rows from a table with optional conditions and ordering.

execute_query

Execute read-only SQL queries.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources