{"id":42603,"library":"db-tanxii-mcp","title":"db-tanxii-mcp","description":"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.","status":"active","version":"1.0.6","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","claude","mcp","database","mysql","oracle","postgres","sqlserver"],"install":[{"cmd":"npm install db-tanxii-mcp","lang":"bash","label":"npm"},{"cmd":"yarn add db-tanxii-mcp","lang":"bash","label":"yarn"},{"cmd":"pnpm add db-tanxii-mcp","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This package is a CLI tool, not a library. Use npm global install or npx to run the MCP server.","wrong":"require('db-tanxii-mcp')","symbol":"db-tanxii-mcp (CLI)","correct":"npx db-tanxii-mcp"},{"note":"Connection URL environment variables must use double underscores: DB_URL__NAME. Single underscore will be ignored.","wrong":"DB_URL_MYSQL=mysql://user:pass@host:port/db","symbol":"Configuration (.env)","correct":"DB_DEFAULT_CONNECTION=MYSQL\nDB_URL__MYSQL=mysql://user:pass@host:port/db"}],"quickstart":{"code":"npm install -g db-tanxii-mcp\n# Prepare configuration file (Windows default path: %APPDATA%/db-tanxii-mcp/.env.production)\necho \"DB_DEFAULT_CONNECTION=MYSQL\" > \"%APPDATA%/db-tanxii-mcp/.env.production\"\necho \"DB_URL__MYSQL=mysql://user:pass@localhost:3306/mydb\" >> \"%APPDATA%/db-tanxii-mcp/.env.production\"\n# Start the MCP server (usually launched by Claude Code)\ndb-tanxii-mcp","lang":"bash","description":"Global installation and minimal configuration to connect to a MySQL database via the MCP server."},"warnings":[{"fix":"Use DB_URL__<name> (e.g., DB_URL__MYSQL) not DB_URL_<name>.","message":"Environment variable keys use double underscores: DB_URL__<name>. Single underscore will not be parsed.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Use the execute tool instead of write_query or similar.","message":"Write operations (INSERT/UPDATE/DELETE) are blocked by default. Must use the 'execute' tool explicitly for writes.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Set ORACLE_CLI_HOME environment variable to the Oracle Instant Client directory.","message":"Oracle connections in Thick mode require ORACLE_CLI_HOME environment variable set to Instant Client directory.","severity":"breaking","affected_versions":">=1.0.0"},{"fix":"Keep the package name as-is in package.json and npm commands.","message":"Package name 'db-tanxii-mcp' is not a typo; it is the correct npm name. Do not rename to db-tanxi-mcp or similar.","severity":"deprecated","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.6':21 'analysi':41 'chines':77 'chinese-languag':76 'claud':9,81 'cli':51 'code':10 'comparison':43 'connect':25 'dameng':17 'databas':5,59,83 'db':2 'db-tanxii-mcp':1 'ddl':37 'design':69 'differenti':55 'document':79 'enforc':34 'environ':28 'execut':39,73 'explicit':72 'explor':36 'first':68 'javascript':80 'languag':78 'manag':26 'mcp':4,6,64,82 'multi':24,58 'multi-connect':23 'multi-databas':57 'mysql':12,84 'npm':50 'oceanbas':19 'oracl':13,85 'plan':40 'postgr':86 'postgresql':14 'provid':22 'read':31 'read-on':30 'regular':53 'releas':47 'requir':71 'retriev':38 'safeti':33 'schema':35 'secur':67 'security-first':66 'server':7,16,65 'singl':63 'sql':15,45 'sqlserver':87 'structur':42 'support':11,60 'tanxii':3 'tool':52,74 'translat':46 'updat':54 'variabl':29 'version':20 'via':27 'write':70","created_at":"2026-06-05T16:55:46.679495+00:00","updated_at":"2026-06-05T16:55:46.679495+00:00","problems":[{"fix":"Run 'npm install -g db-tanxii-mcp' to install globally.","cause":"Package not installed globally or npx path not set.","error":"Error: Cannot find module 'db-tanxii-mcp'"},{"fix":"Use DB_URL__<name> format. Example: DB_URL__MYSQL=mysql://user:pass@host:port/db","cause":"Missing or malformed environment variable keys. Double underscore format required.","error":"MCP server not starting: Invalid configuration. Check DATABASE_URL_* env vars."}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"db-tanxii-mcp","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}