JDBCX MCP Server

Remote

Scanned

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the Smithery and MCP SDKs using npm:

npm install @smithery/sdk @modelcontextprotocol/sdk

TypeScript SDK

Use Smithery's TypeScript SDK to connect to this MCP server:

typescript


import { createTransport } from "@smithery/sdk/transport.js"

const transport = createTransport("https://server.smithery.ai/@jdbcx/pydbcx-mcp/ws", {
  "maxRowsLimit": 1000,
  "mcpTransport": "stdio",
  "jdbcxLogLevel": "DEBUG",
  "mcpServerHost": "0.0.0.0",
  "mcpServerPort": 8080,
  "jdbcxServerUrl": "http://localhost:8080",
  "defaultRowsLimit": 100,
  "jdbcxServerToken": "",
  "defaultDataFormat": "csv",
  "defaultQueryTimeoutSeconds": 10
}, "your-smithery-api-key")

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

// Example: Call a tool
// const result = await client.callTool("tool_name", { param1: "value1" })

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [],
  "properties": {
    "maxRowsLimit": {
      "type": "number",
      "default": 1000,
      "description": "Maximum number of rows allowed"
    },
    "mcpTransport": {
      "type": "string",
      "default": "stdio",
      "description": "MCP transport mechanism"
    },
    "jdbcxLogLevel": {
      "type": "string",
      "default": "DEBUG",
      "description": "Log level for the JDBCX MCP Server"
    },
    "mcpServerHost": {
      "type": "string",
      "default": "0.0.0.0",
      "description": "MCP server bind address"
    },
    "mcpServerPort": {
      "type": "number",
      "default": 8080,
      "description": "MCP server port"
    },
    "jdbcxServerUrl": {
      "type": "string",
      "default": "http://localhost:8080",
      "description": "JDBCX server URL"
    },
    "defaultRowsLimit": {
      "type": "number",
      "default": 100,
      "description": "Default number of rows returned"
    },
    "jdbcxServerToken": {
      "type": "string",
      "default": "",
      "description": "JDBCX server access token"
    },
    "defaultDataFormat": {
      "type": "string",
      "default": "csv",
      "description": "Default data format (e.g., md, jsonl, csv)"
    },
    "defaultQueryTimeoutSeconds": {
      "type": "number",
      "default": 10,
      "description": "Default query timeout in seconds"
    }
  }
}