Managed MCP Server API Tacnode provides managed MCP Server through https://mcp-server.tacnode.io/mcp
Bearer Token is required during the authentication. The token is generated from Nodegroup Overview ->MCP Tokens .
Request: list all tables under public schema.
{ method: "resources/list" params: {} } Response:
{ " resources " : [ { " uri " : "postgres://host:port/database/table_name/schema" , " mimeType " : "application/json" , " name " : "table_name" } ] } Request: get the schema for the specified table(including coulmns namesand types)
{ method: "resources/read" params: { "uri" : "resource_uri" } } Response:
{ " contents " : [ { " uri " : "requested_uri" , " mimeType " : "application/json" , " text " : "[{" column_name ":" ... "," data_type ":" ... "}]" } ] } Request: get the available tools.
{ " method " : "tools/list" , " params " : {} } Response:
{ " tools " : [ { " name " : "query" , " description " : "Run a read-only SQL query" , " inputSchema " : { " type " : "object" , " properties " : { " sql " : { " type " : "string" } }, " required " : [ "sql" ] } } ] } Request: execute the read-only query and get the results.
"method" : "tools/call" , "params" : { " name " : "query" , " arguments " : { " sql " : "SELECT * FROM table" } } Response:
{ " content " : [ { " type " : "text" , " text " : "[{ \" column1 \" : \" value1 \" , \" column2 \" : \" value2 \" }]" } ], " isError " : false }