[command]
dsn = "POSTGRES DSN"
read_only = "Enable read-only mode"
explain_check = "Check query plan with `EXPLAIN` before executing"
transport = "Transport type (stdio or sse)"
port = "sse port"
ip_address = "server ip address"
[gomcp]
list_database = "List all databases in the POSTGRES server"
list_table = "List all tables in the POSTGRES server"
create_table = "Create a new table in the POSTGRES server. Make sure you have added proper comments for each column and the table itself"
alter_table = "Alter an existing table in the POSTGRES server. Make sure you have updated comments for each modified column. DO NOT drop table or existing columns!"
alter_table_query = "The SQL query to alter the table"
create_table_query_description = "The SQL query to create the table"
read_query = "Execute a read-only SQL query. Make sure you have knowledge of the table structure before writing WHERE conditions. Call `desc_table` first if necessary"
count_query = "Query the number of rows in a certain table."
write_query = "Execute a write SQL query. Make sure you have knowledge of the table structure before executing the query. Make sure the data types match the columns' definitions"
update_query = "Execute an update SQL query. Make sure you have knowledge of the table structure before executing the query. Make sure there is always a WHERE condition. Call `desc_table` first if necessary"
count_query_name = "Name of the table to count"
desc_table = "Describe table structure"
desc_table_name = "Name of the table to describe"
delete_query = "Execute a delete SQL query. Make sure you have knowledge of the table structure before executing the query. Make sure there is always a WHERE condition. Call `desc_table` first if necessary"
query_execute_description = "Execute the SQL query and return the result"
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/guoling2008/go-mcp-postgres'
If you have feedback or need assistance with the MCP directory API, please join our Discord server