Skip to main content
Glama

go-mcp-postgres

active.en.toml1.81 kB
[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