Managed MCP Server

Tacnode includes a managed MCP Server with token-based authorization, schema inspection, and support for executing read-only queries. To access the MCP Server, a valid token is required.

Prerequisites

Before using MCP Server, you need to create your Data Cloud. The Data Cloud specifies the cloud platform and region where the service will be deployed. Next, set up your compute resource Nodegroup with node size; and create your Database, where defines the tables and schemas.

To create a Data Cloud, refer to the Data Cloud
To create a Nodegroup & Database, refer to Nodegroup

Afterwards, there will be an MCP token entry on the details page of the nodegroup, and the generated token is bound to the corresponding computing and storage resources.

Creating Tokens

Tokens associate SQL execution with specific computational resources (Nodegroup) and storage resources (Database), while granting valid permissions for your account in the selected database. Each token has a 180-day lifespan and cannot be used after it expires.

Token creation relies on platform services. First, enable Platform Service Authorization under Security -> Access Authorization.

To create a token, select the desired Nodegroup for SQL execution. In the Nodegroup Overview, click MCP Tokens to view existing tokens associated with your account.

Click Create Token, input the target Database name, and generate a new token.

To view token details, select the relevant token. You can copy this token and use it for MCP Client access.

Requesting the Tacnode Managed MCP Server

Tacnode provides a managed MCP Server at https://mcp-server.tacnode.io/mcp, using the Streamable HTTP transport protocol. It uses JSON-RPC 2.0 as its wire format. The following examples demonstrate different MCP Client, such as Claude Desktop and MCP Inspector tool to simulate MCP Client requests. When configuring Authentication, enter a valid, non-expired token in the Bearer Token field.

Request from Claude Desktop

Edit the configuration file at:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json

Add the below code:

{
  "mcpServers": {
    "tacnode": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://mcp-server.tacnode.io/mcp",
        "--header",
        "Authorization: Bearer <YOUR_API_KEY>"
      ]
    }
  }
}

After setup, new Tacnode MCP Server is available in Claude -> Settings -> Developers.

The tools tacnode is availabe in the chat box.

Request from MCP Inspector

When using MCP Inspector with local proxy mode, you also need to configure the Proxy Session Token for MCP Inspector.

MCP Server supports the Resources List, Resources Template List and Resources Read interfaces for retrieving metadata details.

MCP Server supports the Tools List and Tools Call interfaces for executing read-only queries directly on the database.

For the complete API documentation, see Managed MCP Server API.

Request from REST Client

You can also access the MCP Server via the REST API. Since it uses JSON-RPC as the wire format, follow the instructions below to submit a request

Use 'Bearer Token' as the Authorization type.
Use 'Content-Type: application/json' and 'Accept: application/json, text/event-stream' as the Headers.
Use 'POST' as the method.
Use the following JSON as request body

{
    "jsonrpc": "2.0",
    "method": "tools/call",
    "params": {
        "name": "query",
        "arguments": {
            "sql": "your query"
        }
    },
    "id": 1
}

Request example:

curl -X POST https://mcp-server.tacnode.io/mcp \
  -H "Content-Type: application/json" \
  -H "Accept: application/json, text/event-stream" \
  -H "Authorization: Bearer <YOUR_TOKEN>" \
  -d '{
    "jsonrpc": "2.0",
    "method": "tools/call",
    "params": {
        "name": "query",
        "arguments": {
            "sql": "SELECT id, name, review_scores_rating FROM listings ORDER BY review_scores_rating DESC LIMIT 5;"
        }
    },
    "id": 1
  }'
  
event: message
data: {
    "result": {
        "content": [
            {
                "type": "text",
                "text": "[\n  {\n    \"id\": \"865896987740150796\",\n    \"name\": \"Home in Arcangues\",\n    \"review_scores_rating\": null\n  },\n  {\n    \"id\": \"865898067341970111\",\n    \"name\": \"Boutique hotel in Küçükçekmece\",\n    \"review_scores_rating\": null\n  },\n  {\n    \"id\": \"865891522478896004\",\n    \"name\": \"Rental unit in Los Angeles\",\n    \"review_scores_rating\": null\n  },\n  {\n    \"id\": \"865894651971692294\",\n    \"name\": \"Rental unit in Madrid\",\n    \"review_scores_rating\": null\n  },\n  {\n    \"id\": \"865898448046663394\",\n    \"name\": \"Rental unit in Maltepe\",\n    \"review_scores_rating\": null\n  }\n]"
            }
        ],
        "isError": false
    },
    "jsonrpc": "2.0",
    "id": 1
}