halim-23/postgresql-mcp-server
If you are the rightful owner of postgresql-mcp-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 henry@mcphub.com.
The PostgreSQL MCP Server is a comprehensive server that enables AI agents to interact with PostgreSQL databases through a standardized interface, supporting all major database operations.
Tools
Functions exposed to the LLM to take actions
connect_postgres
Connect to PostgreSQL database
execute_query
Execute any SQL query
list_tables
List all tables in schema
describe_table
Get table structure details
create_table
Create new tables
insert_data
Insert records into tables
update_data
Update existing records
delete_data
Delete records from tables
create_index
Create database indexes
backup_table
Create table backups
get_database_info
Get database information
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client