MCP Server for KingbaseES (人大金仓)

A Model Context Protocol server for connecting to KingbaseES (人大金仓) databases in SQL Server compatible mode, with full PostGIS spatial query support.

Features

• 10 MCP tools: Query, execute, list tables, describe schema, spatial queries
• SQL Server compatible: Uses T-SQL syntax on KingbaseES SQL Server compatibility mode
• Spatial queries: PostGIS-powered spatial operations (intersects, within, distance, nearby)
• GeoJSON output: Geometry columns automatically converted to GeoJSON format
• Secure: Connection credentials passed via environment variables

Installation

npm install -g mcp-server-kingbasees

Configuration

Add to your .claude/settings.local.json:

{
  "mcpServers": {
    "kingbasees": {
      "command": "npx",
      "args": ["mcp-server-kingbasees"],
      "env": {
        "DB_HOST": "your-kingbasees-host",
        "DB_PORT": "54321",
        "DB_DATABASE": "your-database",
        "DB_USER": "your-username",
        "DB_PASSWORD": "your-password"
      }
    }
  }
}

Environment Variables

| Variable | Required | Default | Description | |----------|----------|---------|-------------| | DB_HOST | Yes | - | KingbaseES server host | | DB_PORT | Yes | - | Port (typically 54321) | | DB_DATABASE | Yes | - | Database name | | DB_USER | Yes | - | Database user | | DB_PASSWORD | Yes | - | Database password | | DB_CONNECTION_TIMEOUT | No | 30000 | Connection timeout (ms) | | DB_STATEMENT_TIMEOUT | No | 60000 | Statement timeout (ms) |

Tools

General

• read_query - Execute SELECT queries
• execute_query - Execute INSERT/UPDATE/DELETE
• list_tables - List all user tables and views
• describe_table - View table column structure
• get_databases - List all databases

Spatial

• spatial_query - Execute spatial query with GeoJSON output
• spatial_intersects - Find records intersecting with geometry
• spatial_within - Find records within geometry
• spatial_distance - Find records within distance
• spatial_nearby - Find nearby records ordered by distance

Requirements

• Node.js >= 18
• KingbaseES V8 (SQL Server compatible mode)
• KingbaseSpatial (PostGIS 3.4+) extension installed

License

MIT