bogartusmaximus/mcp-server-postgres
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 dayong@mcphub.com.
A Dockerized Micro-Agent Communication Protocol (MCP) server for PostgreSQL database interaction.
Tools
Functions exposed to the LLM to take actions
postgres_connect
Establishes a connection to the PostgreSQL database.
postgres_disconnect
Closes the connection to the PostgreSQL database.
postgres_health_check
Performs a health check on the PostgreSQL database connection.
postgres_execute_query
Executes a SQL query on the PostgreSQL database.
postgres_fetch_data
Fetches data from the PostgreSQL database.
postgres_count_records
Counts the number of records in a PostgreSQL table.
postgres_create_table
Creates a new table in the PostgreSQL database.
postgres_drop_table
Drops a table from the PostgreSQL database.
postgres_list_tables
Lists all tables in the PostgreSQL database.
postgres_describe_table
Describes the structure of a PostgreSQL table.
postgres_insert_data
Inserts data into a PostgreSQL table.
postgres_update_data
Updates data in a PostgreSQL table.
postgres_delete_data
Deletes data from a PostgreSQL table.
postgres_backup_table
Backs up a PostgreSQL table.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client