{"versions":{"0.21.3":{"name":"@olianate/dbhub","version":"0.21.3","mcpName":"io.github.olianate/dbhub","description":"Minimal, token-efficient Database MCP Server with DM8 support (PostgreSQL, MySQL, SQL Server, SQLite, MariaDB, DM8)","repository":{"type":"git","url":"git+https://github.com/olianate/dbhub.git"},"main":"dist/index.js","type":"module","bin":{"dbhub":"dist/index.js"},"scripts":{"build":"pnpm run generate:api-types && tsup && cd frontend && pnpm run build","build:backend":"pnpm run generate:api-types && tsup","build:frontend":"cd frontend && pnpm run build","start":"node --openssl-legacy-provider dist/index.js","dev":"concurrently --kill-others \"pnpm run dev:backend\" \"pnpm run dev:frontend\"","dev:backend":"NODE_OPTIONS=--openssl-legacy-provider NODE_ENV=development tsx src/index.ts --transport=http","dev:frontend":"cd frontend && pnpm run dev","crossdev":"cross-env NODE_OPTIONS=--openssl-legacy-provider NODE_ENV=development tsx src/index.ts","generate:api-types":"openapi-typescript src/api/openapi.yaml -o src/api/openapi.d.ts","test":"vitest run","test:unit":"vitest run --project unit","test:watch":"vitest","test:integration":"vitest run --project integration","test:build":"node scripts/smoke-test-build.mjs"},"engines":{"node":">=20"},"keywords":[],"author":"","license":"MIT","dependencies":{"@iarna/toml":"^2.2.5","@modelcontextprotocol/sdk":"^1.29.0","dotenv":"^16.6.1","express":"^4.22.1","ssh-config":"^5.1.0","ssh2":"^1.17.0","zod":"^3.25.76"},"optionalDependencies":{"@aws-sdk/rds-signer":"^3.1038.0","@azure/identity":"^4.13.1","better-sqlite3":"^11.10.0","dmdb":"^1.0.48286","mariadb":"^3.5.2","mssql":"^11.0.1","mysql2":"^3.22.3","pg":"^8.20.0"},"devDependencies":{"@testcontainers/mariadb":"^11.14.0","@testcontainers/mssqlserver":"^11.14.0","@testcontainers/mysql":"^11.14.0","@testcontainers/postgresql":"^11.14.0","@types/better-sqlite3":"^7.6.13","@types/express":"^4.17.25","@types/mssql":"^9.1.11","@types/node":"^22.19.17","@types/pg":"^8.20.0","@types/ssh2":"^1.15.5","concurrently":"^9.2.1","cross-env":"^7.0.3","openapi-typescript":"^7.13.0","prettier":"^3.8.3","testcontainers":"^11.14.0","ts-node":"^10.9.2","tsup":"^8.5.1","tsx":"^4.21.0","typescript":"^5.9.3","vitest":"^4.1.5"},"compilerOptions":{"target":"ES2020","module":"NodeNext","moduleResolution":"NodeNext","esModuleInterop":true,"strict":true,"outDir":"dist","rootDir":"src"},"include":["src/**/*"],"gitHead":"025d594927a3960cd092da795184150429ebc52c","types":"./dist/index.d.ts","_id":"@olianate/dbhub@0.21.3","bugs":{"url":"https://github.com/olianate/dbhub/issues"},"homepage":"https://github.com/olianate/dbhub#readme","_nodeVersion":"24.14.1","_npmVersion":"11.12.1","dist":{"integrity":"sha512-nab9z0duoadvnyGzn5fjrjGARXzOHrbUeK7LUJMCzJIgAfjqcmWdj+7FVlhtXnd3+Pncf5J0jKiUhzZEqpwGgw==","shasum":"90da92b1066a3d03fb3cda4b50dd9f7b5d918d55","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@olianate/dbhub/-/dbhub-0.21.3.tgz","fileCount":35,"unpackedSize":3219875,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCICsWX928vADy3kIJ6deUjrIHFeLTKcNCI/irt2hjE9AFAiEAm3zvoKwvDrQSnHpbZrEtoXdmjZLA0oe6YVMBMlqVsr8="}],"size":810411},"_npmUser":{"name":"anonymous","email":"olianate@outlook.com"},"directories":{},"maintainers":[{"name":"anonymous","email":"olianate@outlook.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/dbhub_0.21.3_1777343727688_0.42724166146574016"},"_hasShrinkwrap":false,"_cnpmcore_publish_time":"2026-04-28T02:35:27.925Z","publish_time":1777343727925,"_source_registry_name":"default","contributors":[]},"0.21.2":{"name":"@olianate/dbhub","version":"0.21.2","keywords":[],"author":"","license":"MIT","_id":"@olianate/dbhub@0.21.2","maintainers":[{"name":"anonymous","email":"olianate@outlook.com"}],"homepage":"https://github.com/olianate/dbhub#readme","bugs":{"url":"https://github.com/olianate/dbhub/issues"},"bin":{"dbhub":"dist/index.js"},"dist":{"shasum":"b4cf6546ff697eaa2398aca0898d61e027ebdcc5","tarball":"http://123.232.10.234:8212/nexus/content/groups/npm-public/@olianate/dbhub/-/dbhub-0.21.2.tgz","fileCount":35,"integrity":"sha512-55wNMDUCI+ZQ+X+ZIY0PORgBX1Xdu83M9PoehIZtEzaqeoTWoi/qv10bpz3EhOlMsAknMWlU1PfdpaM+R0q1Fg==","signatures":[{"sig":"MEUCIQDnn2O2WN4SWOFTGoPmkxtw2oOg+qds4NhfnRuMHQkGAAIgGEjjmRfPJJk4BY5fFk8maIQgnXiZ4Y7G+iJf+x1TQ40=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":3224173,"size":816945},"main":"dist/index.js","type":"module","types":"./dist/index.d.ts","engines":{"node":">=20"},"gitHead":"6ea735e9ef8a81aa619e218269286362aac1d4df","include":["src/**/*"],"mcpName":"io.github.olianate/dbhub","scripts":{"dev":"concurrently --kill-others \"pnpm run dev:backend\" \"pnpm run dev:frontend\"","test":"vitest run","build":"pnpm run generate:api-types && tsup && cd frontend && pnpm run build","start":"node --openssl-legacy-provider dist/index.js","crossdev":"cross-env NODE_OPTIONS=--openssl-legacy-provider NODE_ENV=development tsx src/index.ts","test:unit":"vitest run --project unit","test:build":"node scripts/smoke-test-build.mjs","test:watch":"vitest","dev:backend":"NODE_OPTIONS=--openssl-legacy-provider NODE_ENV=development tsx src/index.ts --transport=http","dev:frontend":"cd frontend && pnpm run dev","build:backend":"pnpm run generate:api-types && tsup","build:frontend":"cd frontend && pnpm run build","test:integration":"vitest run --project integration","generate:api-types":"openapi-typescript src/api/openapi.yaml -o src/api/openapi.d.ts"},"_npmUser":{"name":"anonymous","email":"olianate@outlook.com"},"repository":{"url":"git+https://github.com/olianate/dbhub.git","type":"git"},"_npmVersion":"11.12.1","description":"Minimal, token-efficient Database MCP Server with DM8 support (PostgreSQL, MySQL, SQL Server, SQLite, MariaDB, DM8)","directories":{},"_nodeVersion":"24.14.1","dependencies":{"zod":"^3.24.2","ssh2":"^1.16.0","dotenv":"^16.4.7","express":"^4.18.2","ssh-config":"^5.0.3","@iarna/toml":"^2.2.5","@modelcontextprotocol/sdk":"^1.25.1"},"_hasShrinkwrap":false,"compilerOptions":{"module":"NodeNext","outDir":"dist","strict":true,"target":"ES2020","rootDir":"src","esModuleInterop":true,"moduleResolution":"NodeNext"},"devDependencies":{"tsx":"^4.19.3","tsup":"^8.4.0","vitest":"^4.0.6","ts-node":"^10.9.2","prettier":"^3.5.3","@types/pg":"^8.11.11","cross-env":"^7.0.3","typescript":"^5.8.2","@types/node":"^22.13.10","@types/ssh2":"^1.15.5","@types/mssql":"^9.1.7","concurrently":"^9.2.1","@types/express":"^4.17.21","testcontainers":"^11.0.3","openapi-typescript":"^7.10.1","@testcontainers/mysql":"^11.0.3","@types/better-sqlite3":"^7.6.12","@testcontainers/mariadb":"^11.0.3","@testcontainers/postgresql":"^11.0.3","@testcontainers/mssqlserver":"^11.0.3"},"optionalDependencies":{"pg":"^8.13.3","dmdb":"^1.0.0","mssql":"^11.0.1","mysql2":"^3.13.0","mariadb":"^3.4.0","better-sqlite3":"^11.9.0","@azure/identity":"^4.8.0","@aws-sdk/rds-signer":"^3.1001.0"},"_npmOperationalInternal":{"tmp":"tmp/dbhub_0.21.2_1777339491811_0.9678402746958001","host":"s3://npm-registry-packages-npm-production"},"_cnpmcore_publish_time":"2026-04-28T01:24:51.971Z","publish_time":1777339491971,"_source_registry_name":"default","contributors":[]}},"dist-tags":{"latest":"0.21.3"},"name":"@olianate/dbhub","time":{"created":"2026-04-28T02:35:43.655Z","modified":"2026-04-28T02:35:45.106Z","0.21.3":"2026-04-28T02:35:27.925Z","0.21.2":"2026-04-28T01:24:51.971Z"},"readme":"> [!NOTE]  \n> Brought to you by [Bytebase](https://www.bytebase.com/), open-source database DevSecOps platform.\n\n<p align=\"center\">\n<a href=\"https://dbhub.ai/\" target=\"_blank\">\n<picture>\n  <source media=\"(prefers-color-scheme: dark)\" srcset=\"https://raw.githubusercontent.com/bytebase/dbhub/main/docs/images/logo/full-dark.svg\" width=\"75%\">\n  <source media=\"(prefers-color-scheme: light)\" srcset=\"https://raw.githubusercontent.com/bytebase/dbhub/main/docs/images/logo/full-light.svg\" width=\"75%\">\n  <img src=\"https://raw.githubusercontent.com/bytebase/dbhub/main/docs/images/logo/full-light.svg\" width=\"75%\" alt=\"DBHub Logo\">\n</picture>\n</a>\n</p>\n\n```bash\n            +------------------+    +--------------+    +------------------+\n            |                  |    |              |    |                  |\n            |                  |    |              |    |                  |\n            |  Claude Desktop  +--->+              +--->+    PostgreSQL    |\n            |                  |    |              |    |                  |\n            |  Claude Code     +--->+              +--->+    SQL Server    |\n            |                  |    |              |    |                  |\n            |  Cursor          +--->+    DBHub     +--->+    SQLite        |\n            |                  |    |              |    |                  |\n            |  VS Code         +--->+              +--->+    MySQL         |\n            |                  |    |              |    |                  |\n            |  Copilot CLI     +--->+              +--->+    MariaDB       |\n            |                  |    |              |    |                  |\n            |                  |    |              |    |    DM8/Dameng    |\n            |                  |    |              |    |                  |\n            +------------------+    +--------------+    +------------------+\n                 MCP Clients           MCP Server             Databases\n```\n\nDBHub is a zero-dependency, token efficient MCP server implementing the Model Context Protocol (MCP) server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases:\n\n- **Local Development First**: Zero dependency, token efficient with just two MCP tools to maximize context window\n- **Multi-Database**: PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, and DM8 through a single interface\n- **Multi-Connection**: Connect to multiple databases simultaneously with TOML configuration\n- **Guardrails**: Read-only mode, row limiting, and query timeout to prevent runaway operations\n- **Secure Access**: SSH tunneling and SSL/TLS encryption\n\n## Supported Databases\n\nPostgreSQL, MySQL, SQL Server, MariaDB, SQLite, and DM8 (Dameng Database).\n\n## MCP Tools\n\nDBHub implements MCP tools for database operations:\n\n- **[execute_sql](https://dbhub.ai/tools/execute-sql)**: Execute SQL queries with transaction support and safety controls\n- **[search_objects](https://dbhub.ai/tools/search-objects)**: Search and explore database schemas, tables, columns, indexes, and procedures with progressive disclosure\n- **[Custom Tools](https://dbhub.ai/tools/custom-tools)**: Define reusable, parameterized SQL operations in your `dbhub.toml` configuration file\n\n## Workbench\n\nDBHub includes a [built-in web interface](https://dbhub.ai/workbench/overview) for interacting with your database tools. It provides a visual way to execute queries, run custom tools, and view request traces without requiring an MCP client.\n\n![workbench](https://raw.githubusercontent.com/bytebase/dbhub/main/docs/images/workbench/workbench.webp)\n\n## Installation\n\nSee the full [Installation Guide](https://dbhub.ai/installation) for detailed instructions.\n\n### Quick Start\n\n**Docker:**\n\n```bash\ndocker run --rm --init \\\n   --name dbhub \\\n   --publish 8080:8080 \\\n   bytebase/dbhub \\\n   --transport http \\\n   --port 8080 \\\n   --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n**NPM:**\n\n```bash\nnpx @bytebase/dbhub@latest --transport http --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n**Demo Mode:**\n\n```bash\nnpx @bytebase/dbhub@latest --transport http --port 8080 --demo\n```\n\nSee [Command-Line Options](https://dbhub.ai/config/command-line) for all available parameters.\n\n### Multi-Database Setup\n\nConnect to multiple databases simultaneously using TOML configuration files. Perfect for managing production, staging, and development databases from a single DBHub instance.\n\nSee [Multi-Database Configuration](https://dbhub.ai/config/toml) for complete setup instructions.\n\n## Development\n\n```bash\n# Install dependencies\npnpm install\n\n# Run in development mode\npnpm dev\n\n# Build and run for production\npnpm build && pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nSee [Testing](.claude/skills/testing/SKILL.md) and [Debug](https://dbhub.ai/config/debug).\n\n## Contributors\n\n<a href=\"https://github.com/bytebase/dbhub/graphs/contributors\">\n  <img src=\"https://contrib.rocks/image?repo=bytebase/dbhub\" />\n</a>\n\n## Star History\n\n<a href=\"https://www.star-history.com/?repos=bytebase%2Fdbhub&type=date&legend=top-left\">\n <picture>\n   <source media=\"(prefers-color-scheme: dark)\" srcset=\"https://api.star-history.com/chart?repos=bytebase/dbhub&type=date&theme=dark&legend=top-left\" />\n   <source media=\"(prefers-color-scheme: light)\" srcset=\"https://api.star-history.com/chart?repos=bytebase/dbhub&type=date&legend=top-left\" />\n   <img alt=\"Star History Chart\" src=\"https://api.star-history.com/chart?repos=bytebase/dbhub&type=date&legend=top-left\" />\n </picture>\n</a>","users":{}}