satish-kori/postgres-mcp-server
If you are the rightful owner of postgres-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.
A demonstration MCP server built with TypeScript providing tools and resources for AI assistants.
Tools
Functions exposed to the LLM to take actions
get_current_time
Get the current date and time with optional timezone support
calculate
Perform basic mathematical operations (add, subtract, multiply, divide)
get_database_schema
Get database schema information for all tables or a specific table
execute_sql_query
Execute SQL queries directly against the database with multiple output formats
execute_ai_generated_sql
Execute AI-generated SQL queries with explanations
natural_language_query
Convert natural language questions to SQL queries and execute them
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client