db-tanxii-mcp

library1.0.6jsnpmunverified

Database MCP Server for Claude Code supporting MySQL, Oracle, PostgreSQL, SQL Server, Dameng, and OceanBase. Version 1.0.6 provides multi-connection management via environment variables, read-only safety enforcement, schema exploration, DDL retrieval, execution plan analysis, structure comparison, and SQL translation. Released as an npm CLI tool, regularly updated. Differentiated by multi-database support in a single MCP server, security-first design (writes require explicit execute tool), and Chinese-language documentation.

database

npm install db-tanxii-mcp

package ↗

INSTALL

IMPORT

SIG · DB-TANXII-MCP

db-tanxii-mcp

databasejavascriptv1.0.6

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

db-tanxii-mcp (CLI)

✓ npx db-tanxii-mcp

✗ require('db-tanxii-mcp')

This package is a CLI tool, not a library. Use npm global install or npx to run the MCP server.

Configuration (.env)

✓ DB_DEFAULT_CONNECTION=MYSQL DB_URL__MYSQL=mysql://user:pass@host:port/db

✗ DB_URL_MYSQL=mysql://user:pass@host:port/db

Connection URL environment variables must use double underscores: DB_URL__NAME. Single underscore will be ignored.

Global installation and minimal configuration to connect to a MySQL database via the MCP server.

npm install -g db-tanxii-mcp # Prepare configuration file (Windows default path: %APPDATA%/db-tanxii-mcp/.env.production) echo "DB_DEFAULT_CONNECTION=MYSQL" > "%APPDATA%/db-tanxii-mcp/.env.production" echo "DB_URL__MYSQL=mysql://user:pass@localhost:3306/mydb" >> "%APPDATA%/db-tanxii-mcp/.env.production" # Start the MCP server (usually launched by Claude Code) db-tanxii-mcp

Debug

Known issues

breakingEnvironment variable keys use double underscores: DB_URL__<name>. Single underscore will not be parsed.

fix

Use DB_URL__<name> (e.g., DB_URL__MYSQL) not DB_URL_<name>.

affects: >=1.0.0

gotchaWrite operations (INSERT/UPDATE/DELETE) are blocked by default. Must use the 'execute' tool explicitly for writes.

fix

Use the execute tool instead of write_query or similar.

affects: >=1.0.0

breakingOracle connections in Thick mode require ORACLE_CLI_HOME environment variable set to Instant Client directory.

fix

Set ORACLE_CLI_HOME environment variable to the Oracle Instant Client directory.

affects: >=1.0.0

deprecatedPackage name 'db-tanxii-mcp' is not a typo; it is the correct npm name. Do not rename to db-tanxi-mcp or similar.

fix

Keep the package name as-is in package.json and npm commands.

affects: >=1.0.0

Errors

Common errors & fixes

Error: Cannot find module 'db-tanxii-mcp'

Package not installed globally or npx path not set.

fix

Run 'npm install -g db-tanxii-mcp' to install globally.

MCP server not starting: Invalid configuration. Check DATABASE_URL_* env vars.

Missing or malformed environment variable keys. Double underscore format required.

fix

Use DB_URL__<name> format. Example: DB_URL__MYSQL=mysql://user:pass@host:port/db

Upgrade

Version history

1.0.6latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

6 hits · last 30 days

node

Resources

packagedb-tanxii-mcp ↗