[{"_1":2,"_396":-5,"_397":-5},"loaderData",{"_3":4,"_22":23,"_24":25,"_293":294},"root",{"_5":6,"_7":8},"toasts",[],"visitor",{"_9":10,"_11":12},"viewportWidth",1280,"visitorSession",{"_13":14,"_16":17,"_18":-5,"_19":20,"_21":-5},"attributes",[15],"BOT","id",8780354,"membership","referenceId","0197c85f-34b4-7020-804a-1f56d7353f19","userAccount","routes/_public/_layout",{},"routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_26":27,"_78":-5,"_79":40,"_29":80,"_211":212,"_292":145},"availableLocales",[28,40,46,52,59,66,72],{"_29":30,"_33":37,"_38":39},"mcpServer",{"_31":32,"_33":34,"_35":36},"description","Universeller Datenbank-MCP-Server mit Verbindung zu MySQL, PostgreSQL, SQLite, DuckDB usw.","name","DBHub","readme","DBHub ist ein universelles Datenbank-Gateway, das die Serverschnittstelle des Model Context Protocol (MCP) implementiert. Dieses Gateway ermöglicht MCP-kompatiblen Clients die Verbindung zu verschiedenen Datenbanken und deren Nutzung.\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## Demo-SSE-Endpunkt\n\n verbindet eine [Beispiel-Mitarbeiterdatenbank](https://github.com/bytebase/employee-sample-database) . Sie können mit Cursor oder MCP Inspector darauf zeigen, um sie in Aktion zu sehen.\n\n![MCP-Inspektor](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## Unterstützte Matrix\n\n### Datenbankressourcen\n\n| Ressourcenname | URI-Format | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Orakel |\n| -------------------------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :--------: | :----: | :----: |\n| Schemata | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Tabellen\\_im\\_Schema | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Tabellenstruktur im Schema | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Indizes\\_in\\_Tabelle | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Prozeduren\\_im\\_Schema | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| Prozedurdetails im Schema | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### Datenbanktools\n\n| Werkzeug | Befehlsname | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Orakel |\n| ----------------- | ----------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| SQL ausführen | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Listenkonnektoren | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### Eingabeaufforderungsfunktionen\n\n| Prompt | Befehlsname | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Orakel |\n| -------------------- | -------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| SQL generieren | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| DB-Elemente erklären | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## Installation\n\n### Docker\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### NPM\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> Hinweis: Der Demomodus enthält eine gebündelte SQLite-Beispieldatenbank „Mitarbeiter“ mit Tabellen für Mitarbeiter, Abteilungen, Gehälter und mehr.\n\n### Claude Desktop\n\n![Claude-Desktop](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop unterstützt nur `stdio` -Transport \n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### Cursor\n\n![Cursor](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* Cursor unterstützt sowohl `stdio` als auch `sse` .\n* Folgen Sie [der Cursor-MCP-Anleitung](https://docs.cursor.com/context/model-context-protocol) und stellen Sie sicher, dass Sie den [Agentenmodus](https://docs.cursor.com/chat/agent) verwenden.\n\n## Verwendung\n\n### SSL-Verbindungen\n\nSie können den SSL-Modus mit dem Parameter `sslmode` in Ihrer DSN-Zeichenfolge angeben:\n\n| Datenbank | `sslmode=disable` | `sslmode=require` | Standardmäßiges SSL-Verhalten |\n| ---------- | :---------------: | :---------------: | :----------------------------------------: |\n| PostgreSQL | ✅ | ✅ | Zertifikatsüberprüfung |\n| MySQL | ✅ | ✅ | Zertifikatsüberprüfung |\n| MariaDB | ✅ | ✅ | Zertifikatsüberprüfung |\n| SQL Server | ✅ | ✅ | Zertifikatsüberprüfung |\n| Orakel | ✅ | ✅ | N/A (Oracle-Clientkonfiguration verwenden) |\n| SQLite | ❌ | ❌ | N/A (dateibasiert) |\n\n**SSL-Modusoptionen:**\n\n* `sslmode=disable` : Die gesamte SSL/TLS-Verschlüsselung ist deaktiviert. Die Daten werden im Klartext übertragen.\n* `sslmode=require` : Die Verbindung ist verschlüsselt, das Serverzertifikat wird jedoch nicht überprüft. Dies bietet Schutz vor Paket-Sniffing, jedoch nicht vor Man-in-the-Middle-Angriffen. Sie können dies für vertrauenswürdige, selbstsignierte Zertifizierungsstellen verwenden.\n\nOhne Angabe von `sslmode` verwenden die meisten Datenbanken standardmäßig die Zertifikatsüberprüfung, die das höchste Maß an Sicherheit bietet.\n\nAnwendungsbeispiel:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### Schreibgeschützter Modus\n\nSie können DBHub im schreibgeschützten Modus ausführen, wodurch die Ausführung von SQL-Abfragen auf schreibgeschützte Vorgänge beschränkt wird:\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nIm schreibgeschützten Modus sind nur [schreibgeschützte SQL-Operationen](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) zulässig.\n\nDies bietet eine zusätzliche Sicherheitsebene beim Herstellen einer Verbindung mit Produktionsdatenbanken.\n\n### Konfigurieren der Datenbankverbindung\n\nSie können DBHub im Demomodus mit einer Beispiel-Mitarbeiterdatenbank zum Testen verwenden:\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\nFür echte Datenbanken ist ein Datenbankquellenname (DSN) erforderlich. Sie können diesen auf verschiedene Arten angeben:\n\n* **Befehlszeilenargument** (höchste Priorität):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **Umgebungsvariable** (zweite Priorität):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **Umgebungsdatei** (dritte Priorität):\n\n * Für die Entwicklung: Erstellen Sie `.env.local` mit Ihrem DSN\n * Für die Produktion: Erstellen Sie `.env` mit Ihrem DSN GXP14\n\n> \\[!WARNING] Verwenden Sie bei der Ausführung in Docker `host.docker.internal` anstelle von `localhost` , um eine Verbindung mit Datenbanken herzustellen, die auf Ihrem Hostcomputer ausgeführt werden. Beispiel: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub unterstützt die folgenden Datenbankverbindungszeichenfolgenformate:\n\n| Datenbank | DSN-Format | Beispiel |\n| ---------- | --------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL Server | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` oder `sqlite::memory:` | `sqlite:///path/to/database.db` , `sqlite:C:/Users/YourName/data/database.db (windows)` oder `sqlite::memory:` |\n| Orakel | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### Orakel\n\nWenn der Fehler „NJS-138: Verbindungen zu dieser Datenbankserverversion werden von Node-OracleDB im Thin-Modus nicht unterstützt“ angezeigt wird, müssen Sie den Thick-Modus wie unten beschrieben verwenden.\n\n##### Docker\n\nVerwenden Sie `bytebase/dbhub-oracle-thick` anstelle des Docker-Images `bytebase/dbhub` .\n\n##### npx\n\n1. Laden Sie [Oracle Instant Client](https://www.oracle.com/database/technologies/instant-client/downloads.html) für Ihre Plattform herunter und installieren Sie ihn\n2. Legen Sie die Umgebungsvariable `ORACLE_LIB_DIR` auf den Pfad Ihres Oracle Instant Client fest:\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL Server\n\nZusätzliche Abfrageparameter:\n\n#### Authentifizierung\n\n* `authentication=azure-active-directory-access-token` . Gilt nur bei Ausführung über Azure. Siehe [DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility) .\n\n### Transport\n\n* **stdio** (Standard) – für die direkte Integration mit Tools wie Claude Desktop:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **sse** – für Browser- und Netzwerkclients:\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Befehlszeilenoptionen\n\n| Option | Beschreibung | Standard |\n| ---------------- | ------------------------------------------------------------------ | ------------------------------------- |\n| Demo | Im Demomodus mit einer Beispiel-Mitarbeiterdatenbank ausführen | `false` |\n| dsn | Datenbankverbindungszeichenfolge | Erforderlich, wenn nicht im Demomodus |\n| Transport | Transportmodus: `stdio` oder `sse` | `stdio` |\n| Hafen | HTTP-Server-Port (nur anwendbar bei Verwendung `--transport=sse` ) | `8080` |\n| schreibgeschützt | Beschränken Sie die SQL-Ausführung auf schreibgeschützte Vorgänge | `false` |\n\nDer Demomodus verwendet eine In-Memory-SQLite-Datenbank mit der [Beispiel-Mitarbeiterdatenbank](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) . Diese enthält Tabellen für Mitarbeiter, Abteilungen, Titel, Gehälter, Abteilungsmitarbeiter und Abteilungsleiter. Die Beispieldatenbank enthält SQL-Skripte zum Erstellen, Laden und Testen von Tabellen.\n\n## Entwicklung\n\n1. Installieren Sie Abhängigkeiten:\n\n ```bash\n pnpm install\n ```\n\n2. Im Entwicklungsmodus ausführen:\n\n ```bash\n pnpm dev\n ```\n\n3. Für die Produktion erstellen:\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Testen\n\nDas Projekt verwendet Vitest zum Testen:\n\n* Tests ausführen: `pnpm test`\n* Führen Sie Tests im Überwachungsmodus aus: `pnpm test:watch`\n\n#### Pre-Commit-Hooks (für Entwickler)\n\nDas Projekt enthält Pre-Commit-Hooks, um vor jedem Commit automatisch Tests auszuführen:\n\n1. Richten Sie nach dem Klonen des Repository die Pre-Commit-Hooks ein:\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. Dadurch wird sichergestellt, dass die Testsuite automatisch ausgeführt wird, wenn Sie einen Commit erstellen, und Commits werden verhindert, die Tests unterbrechen würden.\n\n### Debuggen mit [MCP Inspector](https://github.com/modelcontextprotocol/inspector)\n\n#### stdio\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### SSE\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nStellen Sie eine Verbindung zum DBHub-Server-Endpunkt `/sse` her\n\n## Mitwirkende\n\n## Sternengeschichte\n\n[![Sternenverlaufsdiagramm](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","German","tag","de-DE",{"_29":41,"_33":44,"_38":45},{"_31":42,"_33":34,"_35":43},"Universal database MCP server connecting to MySQL, PostgreSQL, SQLite, DuckDB and etc.","

\n\n\n \n\n\n

\n\nDBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface. This gateway allows MCP-compatible clients to connect to and explore different databases.\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## Demo SSE Endpoint\n\nhttps://demo.dbhub.ai/sse connects a [sample employee database](https://github.com/bytebase/employee-sample-database). You can point Cursor or MCP Inspector to it to see it in action.\n\n![mcp-inspector](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## Supported Matrix\n\n### Database Resources\n\n| Resource Name | URI Format | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Oracle |\n| --------------------------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :--------: | :----: | :----: |\n| schemas | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| tables_in_schema | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| table_structure_in_schema | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| indexes_in_table | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| procedures_in_schema | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| procedure_details_in_schema | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### Database Tools\n\n| Tool | Command Name | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Oracle |\n| --------------- | ----------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| Execute SQL | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| List Connectors | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### Prompt Capabilities\n\n| Prompt | Command Name | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite | Oracle |\n| ------------------- | -------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| Generate SQL | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Explain DB Elements | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## Installation\n\n### Docker\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### NPM\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> Note: The demo mode includes a bundled SQLite sample \"employee\" database with tables for employees, departments, salaries, and more.\n\n### Claude Desktop\n\n![claude-desktop](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n- Claude Desktop only supports `stdio` transport https://github.com/orgs/modelcontextprotocol/discussions/16\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### Cursor\n\n![cursor](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n- Cursor supports both `stdio` and `sse`.\n- Follow [Cursor MCP guide](https://docs.cursor.com/context/model-context-protocol) and make sure to use [Agent](https://docs.cursor.com/chat/agent) mode.\n\n## Usage\n\n### SSL Connections\n\nYou can specify the SSL mode using the `sslmode` parameter in your DSN string:\n\n| Database | `sslmode=disable` | `sslmode=require` | Default SSL Behavior |\n|------------|:----------------:|:----------------:|:-------------------:|\n| PostgreSQL | ✅ | ✅ | Certificate verification |\n| MySQL | ✅ | ✅ | Certificate verification |\n| MariaDB | ✅ | ✅ | Certificate verification |\n| SQL Server | ✅ | ✅ | Certificate verification |\n| Oracle | ✅ | ✅ | N/A (use Oracle client config) |\n| SQLite | ❌ | ❌ | N/A (file-based) |\n\n**SSL Mode Options:**\n\n- `sslmode=disable`: All SSL/TLS encryption is turned off. Data is transmitted in plaintext.\n- `sslmode=require`: Connection is encrypted, but the server's certificate is not verified. This provides protection against packet sniffing but not against man-in-the-middle attacks. You may use this for trusted self-signed CA.\n\nWithout specifying `sslmode`, most databases default to certificate verification, which provides the highest level of security.\n\nExample usage:\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### Read-only Mode\n\nYou can run DBHub in read-only mode, which restricts SQL query execution to read-only operations:\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nIn read-only mode, only [readonly SQL operations](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) are allowed.\n\nThis provides an additional layer of security when connecting to production databases.\n\n### Configure your database connection\n\nYou can use DBHub in demo mode with a sample employee database for testing:\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\nFor real databases, a Database Source Name (DSN) is required. You can provide this in several ways:\n\n- **Command line argument** (highest priority):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n- **Environment variable** (second priority):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n- **Environment file** (third priority):\n - For development: Create `.env.local` with your DSN\n - For production: Create `.env` with your DSN\n ```\n DSN=postgres://user:password@localhost:5432/dbname?sslmode=disable\n ```\n\n> [!WARNING]\n> When running in Docker, use `host.docker.internal` instead of `localhost` to connect to databases running on your host machine. For example: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub supports the following database connection string formats:\n\n| Database | DSN Format | Example |\n| ---------- | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL Server | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` or `sqlite::memory:` | `sqlite:///path/to/database.db`, `sqlite:C:/Users/YourName/data/database.db (windows)` or `sqlite::memory:` |\n| Oracle | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### Oracle\n\nIf you see the error \"NJS-138: connections to this database server version are not supported by node-oracledb in Thin mode\", you need to use Thick mode as described below.\n\n##### Docker\n\nUse `bytebase/dbhub-oracle-thick` instead of `bytebase/dbhub` docker image.\n\n##### npx\n\n1. Download and install [Oracle Instant Client](https://www.oracle.com/database/technologies/instant-client/downloads.html) for your platform\n1. Set the `ORACLE_LIB_DIR` environment variable to the path of your Oracle Instant Client:\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL Server\n\nExtra query parameters:\n\n#### authentication\n\n- `authentication=azure-active-directory-access-token`. Only applicable when running from Azure. See [DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility).\n\n### Transport\n\n- **stdio** (default) - for direct integration with tools like Claude Desktop:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n- **sse** - for browser and network clients:\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Command line options\n\n| Option | Description | Default |\n| --------- | --------------------------------------------------------------- | ---------------------------- |\n| demo | Run in demo mode with sample employee database | `false` |\n| dsn | Database connection string | Required if not in demo mode |\n| transport | Transport mode: `stdio` or `sse` | `stdio` |\n| port | HTTP server port (only applicable when using `--transport=sse`) | `8080` |\n| readonly | Restrict SQL execution to read-only operations | `false` |\n\nThe demo mode uses an in-memory SQLite database loaded with the [sample employee database](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) that includes tables for employees, departments, titles, salaries, department employees, and department managers. The sample database includes SQL scripts for table creation, data loading, and testing.\n\n## Development\n\n1. Install dependencies:\n\n ```bash\n pnpm install\n ```\n\n1. Run in development mode:\n\n ```bash\n pnpm dev\n ```\n\n1. Build for production:\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Testing\n\nThe project uses Vitest for testing:\n\n- Run tests: `pnpm test`\n- Run tests in watch mode: `pnpm test:watch`\n\n#### Pre-commit Hooks (for Developers)\n\nThe project includes pre-commit hooks to run tests automatically before each commit:\n\n1. After cloning the repository, set up the pre-commit hooks:\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. This ensures the test suite runs automatically whenever you create a commit, preventing commits that would break tests.\n\n### Debug with [MCP Inspector](https://github.com/modelcontextprotocol/inspector)\n\n#### stdio\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### SSE\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nConnect to the DBHub server `/sse` endpoint\n\n## Contributors\n\n\n

\n\n\n## Star History\n\n[![Star History Chart](https://api.star-history.com/svg?repos=bytebase/dbhub&type=Date)](https://www.star-history.com/#bytebase/dbhub&Date)\n","English","en-US",{"_29":47,"_33":50,"_38":51},{"_31":48,"_33":34,"_35":49},"Servidor de base de datos universal MCP que se conecta a MySQL, PostgreSQL, SQLite, DuckDB, etc.","DBHub es una puerta de enlace de base de datos universal que implementa la interfaz de servidor del Protocolo de Contexto de Modelo (MCP). Esta puerta de enlace permite a los clientes compatibles con MCP conectarse a diferentes bases de datos y explorarlas.\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## Punto final de demostración de SSE\n\n conecta una [base de datos de empleados de ejemplo](https://github.com/bytebase/employee-sample-database) . Puedes usar Cursor o MCP Inspector para verla en acción.\n\n![inspector mcp](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## Matriz soportada\n\n### Recursos de bases de datos\n\n| Nombre del recurso | Formato URI | PostgreSQL | MySQL | MariaDB | Servidor SQL | SQLite | Oráculo |\n| --------------------------------------------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :----------: | :----: | :-----: |\n| esquemas | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| tablas\\_en\\_esquema | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| estructura\\_de\\_tabla\\_en\\_esquema | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| índices\\_en\\_tabla | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| procedimientos\\_en\\_esquema | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| detalles\\_del\\_procedimiento\\_en\\_el\\_esquema | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### Herramientas de base de datos\n\n| Herramienta | Nombre del comando | PostgreSQL | MySQL | MariaDB | Servidor SQL | SQLite | Oráculo |\n| ------------------- | ------------------ | :--------: | :---: | :-----: | :----------: | ------ | :-----: |\n| Ejecutar SQL | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Conectores de lista | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### Capacidades rápidas\n\n| Inmediato | Nombre del comando | PostgreSQL | MySQL | MariaDB | Servidor SQL | SQLite | Oráculo |\n| ------------------------------------------ | ------------------ | :--------: | :---: | :-----: | :----------: | ------ | :-----: |\n| Generar SQL | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Explicar los elementos de la base de datos | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## Instalación\n\n### Estibador\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### NGP\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> Nota: El modo de demostración incluye una base de datos de \"empleados\" de muestra SQLite con tablas para empleados, departamentos, salarios y más.\n\n### Escritorio de Claude\n\n![Claude-escritorio](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop solo admite el transporte `stdio`\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### Cursor\n\n![cursor](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* El cursor admite tanto `stdio` como `sse` .\n* Siga [la guía de Cursor MCP](https://docs.cursor.com/context/model-context-protocol) y asegúrese de utilizar el modo [Agente](https://docs.cursor.com/chat/agent) .\n\n## Uso\n\n### Conexiones SSL\n\nPuede especificar el modo SSL utilizando el parámetro `sslmode` en su cadena DSN:\n\n| Base de datos | `sslmode=disable` | `sslmode=require` | Comportamiento SSL predeterminado |\n| ------------- | :---------------: | :---------------: | :------------------------------------------------: |\n| PostgreSQL | ✅ | ✅ | Verificación del certificado |\n| MySQL | ✅ | ✅ | Verificación del certificado |\n| MariaDB | ✅ | ✅ | Verificación del certificado |\n| Servidor SQL | ✅ | ✅ | Verificación del certificado |\n| Oráculo | ✅ | ✅ | N/A (utilizar la configuración del cliente Oracle) |\n| SQLite | ❌ | ❌ | N/A (basado en archivos) |\n\n**Opciones del modo SSL:**\n\n* `sslmode=disable` : El cifrado SSL/TLS está desactivado. Los datos se transmiten en texto plano.\n* `sslmode=require` : La conexión está cifrada, pero el certificado del servidor no está verificado. Esto proporciona protección contra el rastreo de paquetes, pero no contra ataques de intermediario. Puede usarlo para una CA autofirmada de confianza.\n\nSin especificar `sslmode` , la mayoría de las bases de datos utilizan de manera predeterminada la verificación del certificado, que proporciona el mayor nivel de seguridad.\n\nEjemplo de uso:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### Modo de solo lectura\n\nPuede ejecutar DHub en modo de solo lectura, lo que restringe la ejecución de consultas SQL a operaciones de solo lectura:\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nEn el modo de solo lectura, únicamente se permiten [operaciones SQL de solo lectura](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) .\n\nEsto proporciona una capa adicional de seguridad al conectarse a bases de datos de producción.\n\n### Configurar su conexión de base de datos\n\nPuede utilizar DHub en modo de demostración con una base de datos de empleados de muestra para realizar pruebas:\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\nPara bases de datos reales, se requiere un Nombre de Origen de la Base de Datos (DSN). Puede proporcionarlo de varias maneras:\n\n* **Argumento de línea de comando** (máxima prioridad):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **Variable de entorno** (segunda prioridad):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **Expediente de entorno** (tercera prioridad):\n\n * Para desarrollo: crea `.env.local` con tu DSN\n * Para producción: crea `.env` con tu DSN GXP14\n\n> \\[!ADVERTENCIA] Al ejecutar en Docker, use `host.docker.internal` en lugar de `localhost` para conectarse a las bases de datos que se ejecutan en su equipo host. Por ejemplo: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub admite los siguientes formatos de cadenas de conexión de base de datos:\n\n| Base de datos | Formato DSN | Ejemplo |\n| ------------- | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| Servidor SQL | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` o `sqlite::memory:` | `sqlite:///path/to/database.db` , `sqlite:C:/Users/YourName/data/database.db (windows)` o `sqlite::memory:` |\n| Oráculo | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### Oráculo\n\nSi ve el error \"NJS-138: las conexiones a esta versión del servidor de base de datos no son compatibles con node-oracledb en modo Thin\", debe usar el modo Thick como se describe a continuación.\n\n##### Estibador\n\nUtilice `bytebase/dbhub-oracle-thick` en lugar de la imagen de Docker `bytebase/dbhub` .\n\n##### npx\n\n1. Descargue e instale [Oracle Instant Client](https://www.oracle.com/database/technologies/instant-client/downloads.html) para su plataforma\n2. Establezca la variable de entorno `ORACLE_LIB_DIR` en la ruta de su Oracle Instant Client:\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### Servidor SQL\n\nParámetros de consulta adicionales:\n\n#### autenticación\n\n* `authentication=azure-active-directory-access-token` . Solo aplicable al ejecutar desde Azure. Consulte [DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility) .\n\n### Transporte\n\n* **stdio** (predeterminado): para integración directa con herramientas como Claude Desktop:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **sse** - para clientes de navegador y red:\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Opciones de línea de comandos\n\n| Opción | Descripción | Por defecto |\n| ------------- | ------------------------------------------------------------------------------ | ---------------------------------------------- |\n| manifestación | Ejecutar en modo de demostración con una base de datos de empleados de muestra | `false` |\n| dsn | Cadena de conexión a la base de datos | Obligatorio si no está en modo de demostración |\n| transporte | Modo de transporte: `stdio` o `sse` | `stdio` |\n| puerto | Puerto del servidor HTTP (solo aplicable cuando se utiliza `--transport=sse` ) | `8080` |\n| solo lectura | Restringir la ejecución de SQL a operaciones de solo lectura | `false` |\n\nEl modo de demostración utiliza una base de datos SQLite en memoria que contiene la [base de datos de empleados de ejemplo](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) , que incluye tablas para empleados, departamentos, cargos, salarios, empleados de departamento y gerentes de departamento. La base de datos de ejemplo incluye scripts SQL para la creación de tablas, la carga de datos y las pruebas.\n\n## Desarrollo\n\n1. Instalar dependencias:\n\n ```bash\n pnpm install\n ```\n\n2. Ejecutar en modo de desarrollo:\n\n ```bash\n pnpm dev\n ```\n\n3. Construir para producción:\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Pruebas\n\nEl proyecto utiliza Vitest para realizar pruebas:\n\n* Ejecutar pruebas: `pnpm test`\n* Ejecutar pruebas en modo de vigilancia: `pnpm test:watch`\n\n#### Ganchos de pre-confirmación (para desarrolladores)\n\nEl proyecto incluye ganchos previos a la confirmación para ejecutar pruebas automáticamente antes de cada confirmación:\n\n1. Después de clonar el repositorio, configure los ganchos previos a la confirmación:\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. Esto garantiza que el conjunto de pruebas se ejecute automáticamente cada vez que crea una confirmación, lo que evita confirmaciones que podrían interrumpir las pruebas.\n\n### Depurar con [MCP Inspector](https://github.com/modelcontextprotocol/inspector)\n\n#### estudio\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### SSE\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nConectarse al punto final del servidor `/sse` DBHub\n\n## Colaboradores\n\n## Historia de las estrellas\n\n[![Gráfico de la historia de las estrellas](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","Spanish","es-ES",{"_29":53,"_33":57,"_38":58},{"_31":54,"_33":55,"_35":56},"MySQL、PostgreSQL、SQLite、DuckDB などに接続するユニバーサルデータベース MCP サーバー。","DBハブ","DBHubは、モデルコンテキストプロトコル（MCP）サーバーインターフェースを実装した汎用データベースゲートウェイです。このゲートウェイにより、MCP対応クライアントは様々なデータベースに接続し、情報を参照することができます。\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## デモ SSE エンドポイント\n\n[https://demo.dbhub.ai/sse は](https://demo.dbhub.ai/sse)[サンプルの従業員データベース](https://github.com/bytebase/employee-sample-database)に接続します。Cursor または MCP Inspector でデータベースを指定して、実際の動作を確認できます。\n\n![mcp-inspector](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## サポートされているマトリックス\n\n### データベースリソース\n\n| リソース名 | URI形式 | PostgreSQL | MySQL | マリアDB | SQL サーバー | SQLite | オラクル |\n| ------------ | ------------------------------------------------------ | :--------: | :---: | :---: | :------: | :----: | :--: |\n| スキーマ | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| スキーマ内のテーブル | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| スキーマ内のテーブル構造 | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| テーブル内のインデックス | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| スキーマ内の手順 | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| スキーマ内の手順の詳細 | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### データベースツール\n\n| 道具 | コマンド名 | PostgreSQL | MySQL | マリアDB | SQL サーバー | SQLite | オラクル |\n| -------- | ----------------- | :--------: | :---: | :---: | :------: | ------ | :--: |\n| SQLを実行する | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| リストコネクタ | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### プロンプト機能\n\n| プロンプト | コマンド名 | PostgreSQL | MySQL | マリアDB | SQL サーバー | SQLite | オラクル |\n| --------- | -------------- | :--------: | :---: | :---: | :------: | ------ | :--: |\n| SQLを生成する | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| DB要素を説明する | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## インストール\n\n### ドッカー\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### 国立博物館\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> 注: デモモードには、従業員、部門、給与などのテーブルを含むバンドルされた SQLite サンプル「従業員」データベースが含まれています。\n\n### クロードデスクトップ\n\n![クロード・デスクトップ](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop は`stdio`トランスポートのみをサポートしています\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### カーソル\n\n![カーソル](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* カーソルは`stdio`と`sse`の両方をサポートします。\n* [カーソル MCP ガイド](https://docs.cursor.com/context/model-context-protocol)に従い、必ず[エージェント](https://docs.cursor.com/chat/agent)モードを使用してください。\n\n## 使用法\n\n### SSL接続\n\nDSN 文字列の`sslmode`パラメータを使用して SSL モードを指定できます。\n\n| データベース | `sslmode=disable` | `sslmode=require` | デフォルトのSSL動作 |\n| ---------- | :---------------: | :---------------: | :----------------------: |\n| PostgreSQL | ✅ | ✅ | 証明書の検証 |\n| MySQL | ✅ | ✅ | 証明書の検証 |\n| マリアDB | ✅ | ✅ | 証明書の検証 |\n| SQL サーバー | ✅ | ✅ | 証明書の検証 |\n| オラクル | ✅ | ✅ | 該当なし（Oracle クライアント構成を使用） |\n| SQLite | ❌ | ❌ | N/A (ファイルベース) |\n\n**SSL モードオプション:**\n\n* `sslmode=disable` : すべてのSSL/TLS暗号化が無効になります。データはプレーンテキストで送信されます。\n* `sslmode=require` : 接続は暗号化されますが、サーバーの証明書は検証されません。パケットスニッフィングに対する保護は提供されますが、中間者攻撃に対する保護は提供されません。信頼できる自己署名CAの場合に使用できます。\n\n`sslmode`を指定しないと、ほとんどのデータベースはデフォルトで証明書検証を実行し、最高レベルのセキュリティを実現します。\n\n使用例:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### 読み取り専用モード\n\nDBHub を読み取り専用モードで実行できます。これにより、SQL クエリの実行が読み取り専用操作に制限されます。\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\n読み取り専用モードでは、[読み取り専用の SQL 操作](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts)のみが許可されます。\n\nこれにより、実稼働データベースに接続するときにセキュリティがさらに強化されます。\n\n### データベース接続を構成する\n\nテスト用にサンプル従業員データベースを使用して、DBHub をデモモードで使用できます。\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\n実際のデータベースでは、データベースソース名（DSN）が必要です。これはいくつかの方法で指定できます。\n\n* **コマンドライン引数**（最高優先度）:\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **環境変数**（第2優先度）:\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **環境ファイル**（優先度3）:\n\n * 開発の場合: DSNで`.env.local`を作成します\n * 本番環境の場合: DSN GXP14 で`.env`を作成します。\n\n> \\[!警告] Dockerで実行する場合、ホストマシンで実行されているデータベースに接続するには、 `localhost`ではなく`host.docker.internal`を使用してください。例： `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub は次のデータベース接続文字列形式をサポートしています。\n\n| データベース | DSNフォーマット | 例 |\n| ---------- | --------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| マリアDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL サーバー | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]`または`sqlite::memory:` | `sqlite:///path/to/database.db` 、 `sqlite:C:/Users/YourName/data/database.db (windows)`または`sqlite::memory:` |\n| オラクル | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### オラクル\n\n「NJS-138: このデータベースサーバーバージョンへの接続は、Thin モードの node-oracledb ではサポートされていません」というエラーが表示される場合は、以下に説明するように Thick モードを使用する必要があります。\n\n##### ドッカー\n\nbytebase `bytebase/dbhub` docker イメージの代わりに`bytebase/dbhub-oracle-thick`使用します。\n\n##### npx\n\n1. お使いのプラットフォーム用の[Oracle Instant Clientを](https://www.oracle.com/database/technologies/instant-client/downloads.html)ダウンロードしてインストールします\n2. `ORACLE_LIB_DIR`環境変数を Oracle Instant Client のパスに設定します。\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL サーバー\n\n追加のクエリパラメータ:\n\n#### 認証\n\n* `authentication=azure-active-directory-access-token` 。Azureから実行する場合にのみ適用されます。DefaultAzureCredential [を](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility)参照してください。\n\n### 輸送\n\n* **stdio** (デフォルト) - Claude Desktop などのツールと直接統合する場合:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **sse** - ブラウザおよびネットワーククライアントの場合:\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### コマンドラインオプション\n\n| オプション | 説明 | デフォルト |\n| ------ | -------------------------------------------------- | ------------- |\n| デモ | サンプル従業員データベースを使用してデモモードで実行する | `false` |\n| dsn | データベース接続文字列 | デモモードでない場合は必須 |\n| 輸送 | トランスポートモード: `stdio`または`sse` | `stdio` |\n| ポート | HTTP サーバーポート ( `--transport=sse`を使用する場合にのみ適用されます) | `8080` |\n| 読み取り専用 | SQL 実行を読み取り専用操作に制限する | `false` |\n\nデモモードでは、従業員、部門、役職、給与、部門従業員、部門マネージャーのテーブルを含む[サンプル従業員データベース](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite)がロードされたインメモリSQLiteデータベースを使用します。サンプルデータベースには、テーブル作成、データロード、テスト用のSQLスクリプトが含まれています。\n\n## 発達\n\n1. 依存関係をインストールします:\n\n ```bash\n pnpm install\n ```\n\n2. 開発モードで実行:\n\n ```bash\n pnpm dev\n ```\n\n3. 生産用にビルド:\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### テスト\n\nこのプロジェクトではテストに Vitest を使用します。\n\n* テストを実行: `pnpm test`\n* ウォッチモードでテストを実行する: `pnpm test:watch`\n\n#### コミット前フック（開発者向け）\n\nプロジェクトには、各コミットの前にテストを自動的に実行するための事前コミットフックが含まれています。\n\n1. リポジトリのクローンを作成した後、コミット前のフックを設定します。\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. これにより、コミットを作成するたびにテストスイートが自動的に実行され、テストを中断させるコミットが防止されます。\n\n### [MCP Inspector](https://github.com/modelcontextprotocol/inspector)でデバッグする\n\n#### 標準入出力\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### 南南東\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nDBHubサーバーの`/sse`エンドポイントに接続する\n\n## 寄稿者\n\n## スターの歴史\n\n[![星の歴史チャート](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","Japanese","ja-JP",{"_29":60,"_33":64,"_38":65},{"_31":61,"_33":62,"_35":63},"MySQL, PostgreSQL, SQLite, DuckDB 등에 연결되는 범용 데이터베이스 MCP 서버입니다.","디비허브","DBHub는 MCP(Model Context Protocol) 서버 인터페이스를 구현하는 범용 데이터베이스 게이트웨이입니다. 이 게이트웨이를 통해 MCP 호환 클라이언트는 다양한 데이터베이스에 연결하고 탐색할 수 있습니다.\n\n지엑스피1\n\n## 데모 SSE 엔드포인트\n\n[https://demo.dbhub.ai/sse는](https://demo.dbhub.ai/sse) [샘플 직원 데이터베이스를](https://github.com/bytebase/employee-sample-database) 연결합니다. Cursor 또는 MCP Inspector를 연결하여 실제 작동 모습을 확인할 수 있습니다.\n\n![mcp-검사관](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## 지원되는 매트릭스\n\n### 데이터베이스 리소스\n\n| 리소스 이름 | URI 형식 | 포스트그레스큐엘 | MySQL | 마리아DB | SQL 서버 | SQLite | 신탁 |\n| --------------- | ------------------------------------------------------ | :------: | :---: | :---: | :----: | :----: | :-: |\n| 스키마 | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 스키마의 테이블 | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 스키마의 테이블 구조 | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 테이블의 인덱스 | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 스키마의 프로시저 | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| 스키마의 프로시저 세부 정보 | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### 데이터베이스 도구\n\n| 도구 | 명령 이름 | 포스트그레스큐엘 | MySQL | 마리아DB | SQL 서버 | SQLite | 신탁 |\n| ------ | ----------------- | :------: | :---: | :---: | :----: | ------ | :-: |\n| SQL 실행 | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 목록 커넥터 | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### 신속한 기능\n\n| 즉각적인 | 명령 이름 | 포스트그레스큐엘 | MySQL | 마리아DB | SQL 서버 | SQLite | 신탁 |\n| -------- | -------------- | :------: | :---: | :---: | :----: | ------ | :-: |\n| SQL 생성 | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| DB 요소 설명 | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## 설치\n\n### 도커\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### 국립민간공원\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> 참고: 데모 모드에는 직원, 부서, 급여 등에 대한 테이블이 있는 SQLite 샘플 \"직원\" 데이터베이스가 함께 제공됩니다.\n\n### 클로드 데스크탑\n\n![클로드-데스크톱](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop은 `stdio` 전송만 지원합니다 [. https://github.com/orgs/modelcontextprotocol/discussions/16](https://github.com/orgs/modelcontextprotocol/discussions/16)\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### 커서\n\n![커서](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* 커서는 `stdio` 와 `sse` 모두 지원합니다.\n* [커서 MCP 가이드를](https://docs.cursor.com/context/model-context-protocol) 따르고 [에이전트](https://docs.cursor.com/chat/agent) 모드를 사용하세요.\n\n## 용법\n\n### SSL 연결\n\nDSN 문자열의 `sslmode` 매개변수를 사용하여 SSL 모드를 지정할 수 있습니다.\n\n| 데이터 베이스 | `sslmode=disable` | `sslmode=require` | 기본 SSL 동작 |\n| -------- | :---------------: | :---------------: | :---------------------: |\n| 포스트그레스큐엘 | ✅ | ✅ | 인증서 검증 |\n| MySQL | ✅ | ✅ | 인증서 검증 |\n| 마리아DB | ✅ | ✅ | 인증서 검증 |\n| SQL 서버 | ✅ | ✅ | 인증서 검증 |\n| 신탁 | ✅ | ✅ | N/A(Oracle 클라이언트 구성 사용) |\n| SQLite | ❌ | ❌ | N/A(파일 기반) |\n\n**SSL 모드 옵션:**\n\n* `sslmode=disable` : 모든 SSL/TLS 암호화가 해제됩니다. 데이터는 일반 텍스트로 전송됩니다.\n* `sslmode=require` : 연결은 암호화되지만 서버 인증서는 검증되지 않습니다. 이 설정은 패킷 스니핑으로부터 보호하지만, 중간자 공격(man-in-the-middle attack)으로부터는 보호하지 못합니다. 신뢰할 수 있는 자체 서명 CA에 사용할 수 있습니다.\n\n`sslmode` 지정하지 않으면 대부분의 데이터베이스는 가장 높은 수준의 보안을 제공하는 인증서 검증을 기본적으로 사용합니다.\n\n사용 예:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### 읽기 전용 모드\n\nDBHub를 읽기 전용 모드로 실행하면 SQL 쿼리 실행이 읽기 전용 작업으로 제한됩니다.\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\n읽기 전용 모드에서는 [읽기 전용 SQL 작업](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) 만 허용됩니다.\n\n이렇게 하면 프로덕션 데이터베이스에 연결할 때 보안을 한층 강화할 수 있습니다.\n\n### 데이터베이스 연결 구성\n\n테스트를 위해 샘플 직원 데이터베이스와 함께 데모 모드에서 DBHub를 사용할 수 있습니다.\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\n실제 데이터베이스의 경우 데이터베이스 원본 이름(DSN)이 필요합니다. 다음과 같은 여러 가지 방법으로 제공할 수 있습니다.\n\n* **명령줄 인수** (가장 높은 우선순위):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **환경 변수** (두 번째 우선순위):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **환경 파일** (3번째 우선순위):\n\n * 개발용: DSN으로 `.env.local` 만듭니다.\n * 프로덕션의 경우: DSN GXP14로 `.env` 생성합니다.\n\n> \\[!경고] Docker에서 실행할 때 호스트 머신에서 실행 중인 데이터베이스에 연결하려면 `localhost` 대신 `host.docker.internal` 사용하세요. 예: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub는 다음과 같은 데이터베이스 연결 문자열 형식을 지원합니다.\n\n| 데이터 베이스 | DSN 형식 | 예 |\n| -------- | --------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------ |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| 마리아DB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| 포스트그레스큐엘 | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL 서버 | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` 또는 `sqlite::memory:` | `sqlite:///path/to/database.db` , `sqlite:C:/Users/YourName/data/database.db (windows)` 또는 `sqlite::memory:` |\n| 신탁 | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### 신탁\n\n\"NJS-138: 이 데이터베이스 서버 버전에 대한 연결은 Thin 모드에서 node-oracledb에서 지원되지 않습니다.\"라는 오류가 표시되면 아래 설명된 대로 Thick 모드를 사용해야 합니다.\n\n##### 도커\n\nbytebase/dbhub docker 이미지 대신 `bytebase/dbhub` `bytebase/dbhub-oracle-thick` 사용하세요.\n\n##### 엔피엑스\n\n1. 플랫폼에 맞는 [Oracle Instant Client를](https://www.oracle.com/database/technologies/instant-client/downloads.html) 다운로드하고 설치하세요.\n2. `ORACLE_LIB_DIR` 환경 변수를 Oracle Instant Client 경로로 설정합니다.\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL 서버\n\n추가 쿼리 매개변수:\n\n#### 입증\n\n* `authentication=azure-active-directory-access-token` . Azure에서 실행하는 경우에만 적용됩니다. [DefaultAzureCredential 을](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility) 참조하세요.\n\n### 수송\n\n* **stdio** (기본값) - Claude Desktop과 같은 도구와 직접 통합하기 위해:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **sse** - 브라우저 및 네트워크 클라이언트용:\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### 명령줄 옵션\n\n| 옵션 | 설명 | 기본 |\n| ----- | ------------------------------------------- | ------------------- |\n| 데모 | 샘플 직원 데이터베이스로 데모 모드에서 실행 | `false` |\n| 디에스엔 | 데이터베이스 연결 문자열 | 데모 모드가 아닌 경우 필요합니다. |\n| 수송 | 전송 모드: `stdio` 또는 `sse` | `stdio` |\n| 포트 | HTTP 서버 포트( `--transport=sse` 사용할 때만 적용 가능) | `8080` |\n| 읽기 전용 | SQL 실행을 읽기 전용 작업으로 제한합니다. | `false` |\n\n데모 모드에서는 직원, 부서, 직함, 급여, 부서 직원 및 부서 관리자에 대한 테이블이 포함된 [샘플 직원 데이터베이스가](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) 로드된 인메모리 SQLite 데이터베이스를 사용합니다. 샘플 데이터베이스에는 테이블 생성, 데이터 로드 및 테스트를 위한 SQL 스크립트가 포함되어 있습니다.\n\n## 개발\n\n1. 종속성 설치:\n\n ```bash\n pnpm install\n ```\n\n2. 개발 모드에서 실행:\n\n ```bash\n pnpm dev\n ```\n\n3. 프로덕션을 위해 빌드:\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### 테스트\n\n이 프로젝트에서는 테스트를 위해 Vitest를 사용합니다.\n\n* 테스트 실행: `pnpm test`\n* 감시 모드에서 테스트 실행: `pnpm test:watch`\n\n#### 사전 커밋 후크(개발자용)\n\n이 프로젝트에는 각 커밋 전에 자동으로 테스트를 실행하기 위한 사전 커밋 후크가 포함되어 있습니다.\n\n1. 저장소를 복제한 후, 커밋 전 후크를 설정합니다.\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. 이렇게 하면 커밋을 생성할 때마다 테스트 모음이 자동으로 실행되어 테스트를 중단시키는 커밋이 방지됩니다.\n\n### [MCP Inspector](https://github.com/modelcontextprotocol/inspector) 로 디버깅\n\n#### stdio\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### 남남동\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nDBHub 서버 `/sse` 엔드포인트에 연결합니다.\n\n## 기여자\n\n## 스타 역사\n\n[![별 역사 차트](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","Korean","ko-KR",{"_29":67,"_33":70,"_38":71},{"_31":68,"_33":34,"_35":69},"Универсальный сервер баз данных MCP, подключающийся к MySQL, PostgreSQL, SQLite, DuckDB и т. д.","DBHub — это универсальный шлюз базы данных, реализующий интерфейс сервера Model Context Protocol (MCP). Этот шлюз позволяет клиентам, совместимым с MCP, подключаться к различным базам данных и исследовать их.\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## Демонстрационная конечная точка SSE\n\n подключает [образец базы данных сотрудников](https://github.com/bytebase/employee-sample-database) . Вы можете указать на него Cursor или MCP Inspector, чтобы увидеть его в действии.\n\n![mcp-инспектор](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## Поддерживаемая матрица\n\n### Ресурсы базы данных\n\n| Имя ресурса | Формат URI | PostgreSQL | MySQL | MariaDB | SQL-сервер | SQLite | Оракул |\n| -------------------------------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :--------: | :----: | :----: |\n| схемы | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| таблицы\\_в\\_схеме | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| структура\\_таблицы\\_в\\_схеме | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| индексы\\_в\\_таблице | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| процедуры\\_в\\_схеме | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| подробности\\_процедуры\\_в\\_схеме | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### Инструменты базы данных\n\n| Инструмент | Имя команды | PostgreSQL | MySQL | MariaDB | SQL-сервер | SQLite | Оракул |\n| ------------------- | ----------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| Выполнить SQL | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Список соединителей | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### Возможности промпта\n\n| Быстрый | Имя команды | PostgreSQL | MySQL | MariaDB | SQL-сервер | SQLite | Оракул |\n| --------------------- | -------------- | :--------: | :---: | :-----: | :--------: | ------ | :----: |\n| Сгенерировать SQL | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Объясните элементы БД | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## Установка\n\n### Докер\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### НПМ\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> Примечание: демонстрационный режим включает в себя встроенный пример базы данных SQLite «employee» с таблицами для сотрудников, отделов, зарплат и т. д.\n\n### Клод Десктоп\n\n![Клод-рабочий стол](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop поддерживает только `stdio` -транспорт \n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### Курсор\n\n![курсор](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* Курсор поддерживает как `stdio` , так и `sse` .\n* Следуйте [руководству по Cursor MCP](https://docs.cursor.com/context/model-context-protocol) и обязательно используйте режим [агента](https://docs.cursor.com/chat/agent) .\n\n## Использование\n\n### SSL-соединения\n\nВы можете указать режим SSL с помощью параметра `sslmode` в строке DSN:\n\n| База данных | `sslmode=disable` | `sslmode=require` | Поведение SSL по умолчанию |\n| ----------- | :---------------: | :---------------: | :-------------------------------------------: |\n| PostgreSQL | ✅ | ✅ | Проверка сертификата |\n| MySQL | ✅ | ✅ | Проверка сертификата |\n| MariaDB | ✅ | ✅ | Проверка сертификата |\n| SQL-сервер | ✅ | ✅ | Проверка сертификата |\n| Оракул | ✅ | ✅ | N/A (используйте конфигурацию клиента Oracle) |\n| SQLite | ❌ | ❌ | N/A (на основе файлов) |\n\n**Параметры режима SSL:**\n\n* `sslmode=disable` : Все шифрование SSL/TLS отключено. Данные передаются в открытом виде.\n* `sslmode=require` : Соединение зашифровано, но сертификат сервера не проверен. Это обеспечивает защиту от перехвата пакетов, но не от атак типа «человек посередине». Вы можете использовать это для доверенного самоподписанного CA.\n\nЕсли не указать `sslmode` , большинство баз данных по умолчанию используют проверку сертификатов, что обеспечивает наивысший уровень безопасности.\n\nПример использования:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### Режим только для чтения\n\nВы можете запустить DBHub в режиме только для чтения, который ограничивает выполнение SQL-запросов операциями только для чтения:\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nВ режиме «только чтение» разрешены только [операции SQL, доступные только для чтения](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) .\n\nЭто обеспечивает дополнительный уровень безопасности при подключении к производственным базам данных.\n\n### Настройте подключение к базе данных\n\nВы можете использовать DBHub в демонстрационном режиме с образцом базы данных сотрудников для тестирования:\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\nДля реальных баз данных требуется Database Source Name (DSN). Вы можете предоставить его несколькими способами:\n\n* **Аргумент командной строки** (наивысший приоритет):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **Переменная окружения** (второй приоритет):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **Файл среды** (третий приоритет):\n\n * Для разработки: создайте `.env.local` с вашим DSN\n * Для производства: создайте `.env` с вашим DSN GXP14\n\n> \\[!WARNING] При работе в Docker используйте `host.docker.internal` вместо `localhost` для подключения к базам данных, запущенным на вашем хост-компьютере. Например: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub поддерживает следующие форматы строк подключения к базе данных:\n\n| База данных | Формат DSN | Пример |\n| ----------- | --------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL-сервер | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` или `sqlite::memory:` | `sqlite:///path/to/database.db` , `sqlite:C:/Users/YourName/data/database.db (windows)` или `sqlite::memory:` |\n| Оракул | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### Оракул\n\nЕсли вы видите ошибку «NJS-138: соединения с этой версией сервера базы данных не поддерживаются node-oracledb в тонком режиме», вам необходимо использовать толстый режим, как описано ниже.\n\n##### Докер\n\nИспользуйте образ docker `bytebase/dbhub-oracle-thick` вместо `bytebase/dbhub` .\n\n##### нпх\n\n1. Загрузите и установите [Oracle Instant Client](https://www.oracle.com/database/technologies/instant-client/downloads.html) для вашей платформы\n2. Установите переменную среды `ORACLE_LIB_DIR` на путь к вашему Oracle Instant Client:\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL-сервер\n\nДополнительные параметры запроса:\n\n#### аутентификация\n\n* `authentication=azure-active-directory-access-token` . Применимо только при запуске из Azure. См. [DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility) .\n\n### Транспорт\n\n* **stdio** (по умолчанию) — для прямой интеграции с такими инструментами, как Claude Desktop:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **sse** - для браузерных и сетевых клиентов:\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Параметры командной строки\n\n| Вариант | Описание | По умолчанию |\n| ----------------- | ------------------------------------------------------------------------- | ---------------------------------------------- |\n| демо | Запустить в демонстрационном режиме с образцом базы данных сотрудников | `false` |\n| dsn | Строка подключения к базе данных | Обязательно, если не в демонстрационном режиме |\n| транспорт | Режим транспорта: `stdio` или `sse` | `stdio` |\n| порт | Порт HTTP-сервера (применимо только при использовании `--transport=sse` ) | `8080` |\n| только для чтения | Ограничить выполнение SQL операциями только для чтения | `false` |\n\nДемонстрационный режим использует базу данных SQLite в памяти, загруженную [образцом базы данных сотрудников](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) , которая включает таблицы для сотрудников, отделов, должностей, зарплат, сотрудников отделов и менеджеров отделов. Образец базы данных включает скрипты SQL для создания таблиц, загрузки данных и тестирования.\n\n## Разработка\n\n1. Установить зависимости:\n\n ```bash\n pnpm install\n ```\n\n2. Запустить в режиме разработки:\n\n ```bash\n pnpm dev\n ```\n\n3. Сборка для производства:\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Тестирование\n\nПроект использует Vitest для тестирования:\n\n* Запуск тестов: `pnpm test`\n* Запуск тестов в режиме наблюдения: `pnpm test:watch`\n\n#### Предварительные хуки (для разработчиков)\n\nПроект включает в себя pre-commit hooks для автоматического запуска тестов перед каждым коммитом:\n\n1. После клонирования репозитория настройте pre-commit hooks:\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. Это гарантирует, что набор тестов будет запускаться автоматически при каждом создании коммита, предотвращая создание коммитов, которые могут нарушить тесты.\n\n### Отладка с помощью [MCP Inspector](https://github.com/modelcontextprotocol/inspector)\n\n#### стдио\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### СШЭ\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nПодключитесь к конечной точке сервера DBHub `/sse`\n\n## Участники\n\n## История Звезды\n\n[![Звездная история диаграммы](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","Russian","ru-RU",{"_29":73,"_33":76,"_38":77},{"_31":74,"_33":34,"_35":75},"通用数据库 MCP 服务器连接到 MySQL、PostgreSQL、SQLite、DuckDB 等。","DBHub 是一个通用数据库网关，实现了模型上下文协议 (MCP) 服务器接口。该网关允许兼容 MCP 的客户端连接并探索不同的数据库。\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other MCP +--->+ +--->+ SQLite |\n | Clients | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n | | | +--->+ Oracle |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## 演示 SSE 端点\n\n连接了一个[示例员工数据库](https://github.com/bytebase/employee-sample-database)。您可以将 Cursor 或 MCP Inspector 指向该数据库，以查看其实际运行情况。\n\n![mcp 检查器](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## 支持矩阵\n\n### 数据库资源\n\n| 资源名称 | URI 格式 | PostgreSQL | MySQL | MariaDB | SQL 服务器 | SQLite | 甲骨文 |\n| ---------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :-----: | :----: | :-: |\n| 模式 | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 表结构 | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 表结构 | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 表中索引 | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 过程\\_在\\_架构中 | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n| 过程详细信息 | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ | ✅ |\n\n### 数据库工具\n\n| 工具 | 命令名称 | PostgreSQL | MySQL | MariaDB | SQL 服务器 | SQLite | 甲骨文 |\n| ------ | ----------------- | :--------: | :---: | :-----: | :-----: | ------ | :-: |\n| 执行 SQL | `execute_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 列出连接器 | `list_connectors` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### 提示功能\n\n| 迅速的 | 命令名称 | PostgreSQL | MySQL | MariaDB | SQL 服务器 | SQLite | 甲骨文 |\n| ------- | -------------- | :--------: | :---: | :-----: | :-----: | ------ | :-: |\n| 生成 SQL | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n| 解释数据库元素 | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## 安装\n\n### Docker\n\n```bash\n# PostgreSQL example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --demo\n```\n\n```bash\n# Oracle example\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n```bash\n# Oracle example with thick mode for connecting to 11g or older \ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub-oracle-thick \\\n --transport sse \\\n --port 8080 \\\n --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n### 新公共管理\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport sse --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport sse --port 8080 --demo\n```\n\n> 注意：演示模式包括捆绑的 SQLite 示例“员工”数据库，其中包含员工、部门、工资等表。\n\n### 克劳德桌面\n\n![克劳德桌面](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n* Claude Desktop 仅支持`stdio`传输\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### 光标\n\n![光标](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n* Cursor 同时支持`stdio`和`sse` 。\n* 按照[Cursor MCP 指南](https://docs.cursor.com/context/model-context-protocol)并确保使用[代理](https://docs.cursor.com/chat/agent)模式。\n\n## 用法\n\n### SSL 连接\n\n您可以使用 DSN 字符串中的`sslmode`参数指定 SSL 模式：\n\n| 数据库 | `sslmode=disable` | `sslmode=require` | 默认 SSL 行为 |\n| ---------- | :---------------: | :---------------: | :------------------: |\n| PostgreSQL | ✅ | ✅ | 证书验证 |\n| MySQL | ✅ | ✅ | 证书验证 |\n| MariaDB | ✅ | ✅ | 证书验证 |\n| SQL 服务器 | ✅ | ✅ | 证书验证 |\n| 甲骨文 | ✅ | ✅ | N/A（使用 Oracle 客户端配置） |\n| SQLite | ❌ | ❌ | N/A（基于文件） |\n\n**SSL 模式选项：**\n\n* `sslmode=disable` ：关闭所有 SSL/TLS 加密。数据以明文形式传输。\n* `sslmode=require` ：连接已加密，但不验证服务器证书。这可以防止数据包嗅探，但不能防止中间人攻击。您可以使用受信任的自签名 CA 进行此设置。\n\n如果不指定`sslmode` ，大多数数据库默认使用证书验证，这提供了最高级别的安全性。\n\n使用示例：\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### 只读模式\n\n您可以在只读模式下运行 DBHub，这会将 SQL 查询执行限制为只读操作：\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\n在只读模式下，只允许[进行只读 SQL 操作](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts)。\n\n这在连接到生产数据库时提供了额外的安全层。\n\n### 配置数据库连接\n\n您可以在演示模式下使用 DBHub 和示例员工数据库进行测试：\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\n对于真实数据库，需要数据库源名称 (DSN)。您可以通过以下几种方式提供此信息：\n\n* **命令行参数**（最高优先级）：\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* **环境变量**（第二优先级）：\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n* **环境文件**（第三优先级）：\n\n * 对于开发：使用您的 DSN 创建`.env.local`\n * 对于生产：使用您的 DSN GXP14 创建`.env`\n\n> 警告：在 Docker 中运行时，请使用`host.docker.internal`而不是`localhost`来连接主机上运行的数据库。例如： `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub支持以下数据库连接字符串格式：\n\n| 数据库 | DSN 格式 | 例子 |\n| ---------- | --------------------------------------------------------- | ------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL 服务器 | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]`或`sqlite::memory:` | `sqlite:///path/to/database.db` `sqlite:C:/Users/YourName/data/database.db (windows)`或`sqlite::memory:` |\n| 甲骨文 | `oracle://[user]:[password]@[host]:[port]/[service_name]` | `oracle://username:password@localhost:1521/service_name?sslmode=disable` |\n\n#### 甲骨文\n\n如果您看到错误“NJS-138：在 Thin 模式下，node-oracledb 不支持与此数据库服务器版本的连接”，则需要按照如下所述使用 Thick 模式。\n\n##### Docker\n\n使用`bytebase/dbhub-oracle-thick`代替`bytebase/dbhub` docker 镜像。\n\n##### NPX\n\n1. 下载并安装适合您的平台的[Oracle Instant Client](https://www.oracle.com/database/technologies/instant-client/downloads.html)\n2. 将`ORACLE_LIB_DIR`环境变量设置为 Oracle Instant Client 的路径：\n\n```bash\n# Set environment variable to Oracle Instant Client directory\nexport ORACLE_LIB_DIR=/path/to/instantclient_19_8\n\n# Then run DBHub\nnpx @bytebase/dbhub --dsn \"oracle://username:password@localhost:1521/service_name\"\n```\n\n#### SQL 服务器\n\n额外的查询参数：\n\n#### 验证\n\n* `authentication=azure-active-directory-access-token` 。仅适用于从 Azure 运行时。请参阅[DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility) 。\n\n### 运输\n\n* **stdio** （默认）-用于与 Claude Desktop 等工具直接集成：\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n* \\*\\*sse——\\*\\*适用于浏览器和网络客户端：\n\n ```bash\n npx @bytebase/dbhub --transport sse --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### 命令行选项\n\n| 选项 | 描述 | 默认 |\n| ---- | ------------------------------------ | -------------- |\n| 演示 | 使用示例员工数据库以演示模式运行 | `false` |\n| 域名系统 | 数据库连接字符串 | 如果非处于演示模式则为必填项 |\n| 运输 | 传输模式： `stdio`或`sse` | `stdio` |\n| 港口 | HTTP 服务器端口（仅在使用`--transport=sse`时适用） | `8080` |\n| 只读 | 将 SQL 执行限制为只读操作 | `false` |\n\n演示模式使用内存 SQLite 数据库，其中加载了[示例员工数据库](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite)，其中包含员工、部门、职称、薪资、部门员工和部门经理等表格。示例数据库包含用于创建表、加载数据和测试的 SQL 脚本。\n\n## 发展\n\n1. 安装依赖项：\n\n ```bash\n pnpm install\n ```\n\n2. 以开发模式运行：\n\n ```bash\n pnpm dev\n ```\n\n3. 为生产而构建：\n\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### 测试\n\n项目采用Vitest进行测试：\n\n* 运行测试： `pnpm test`\n* 在监视模式下运行测试： `pnpm test:watch`\n\n#### 预提交钩子（针对开发人员）\n\n该项目包括预提交挂钩，用于在每次提交之前自动运行测试：\n\n1. 克隆存储库后，设置预提交挂钩：\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. 这可确保每次创建提交时测试套件都会自动运行，从而防止破坏测试的提交。\n\n### 使用[MCP Inspector](https://github.com/modelcontextprotocol/inspector)进行调试\n\n#### 标准输入输出\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### 上交所\n\n```bash\n# Start DBHub with SSE transport\npnpm dev --transport=sse --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\n连接到 DBHub 服务器`/sse`端点\n\n## 贡献者\n\n## 星史\n\n[![星空历史图](https://api.star-history.com/svg?repos=bytebase/dbhub\\&type=Date)](https://www.star-history.com/#bytebase/dbhub\\&Date)","Chinese","zh-CN","githubUser","locale",{"_81":82,"_83":84,"_13":104,"_111":42,"_112":42,"_113":114,"_118":119,"_142":-5,"_16":143,"_144":145,"_146":147,"_33":34,"_186":132,"_187":188,"_191":-5,"_192":193,"_194":-5,"_195":196,"_201":-5,"_154":128,"_202":203,"_207":-5,"_133":208,"_209":210},"addedAt","2025-03-13T10:56:17.244244403Z","argumentsJsonSchema",{"_85":86,"_101":102,"_90":103},"properties",{"_87":88,"_92":93,"_97":98},"DSN",{"_31":89,"_90":91},"Database connection string (e.g. postgres://user:password@localhost:5432/dbname?sslmode=disable)","type","string","port",{"_94":95,"_31":96,"_90":91},"default","8080","HTTP server port (only applicable when using sse transport)","transport",{"_94":99,"_31":100,"_90":91},"stdio","Transport mode: stdio or sse","required",[87],"object",[105,106,107,108,109,110],"category:databases","category:developer-tools","category:code-execution","hosting:remote-capable","language:typescript","license_grade:a","descriptionMarkdown","descriptionPlainText","githubProject",{"_35":115,"_116":117},"> [!NOTE] \n> Brought to you by [Bytebase](https://www.bytebase.com/), open-source database DevSecOps platform.\n\n

\n\n\n \n\n\n

\n\n

\n $\"Add$ \n $\"Join$ \n

\n\nDBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface. This gateway allows MCP-compatible clients to connect to and explore different databases.\n\n```bash\n +------------------+ +--------------+ +------------------+\n | | | | | |\n | | | | | |\n | Claude Desktop +--->+ +--->+ PostgreSQL |\n | | | | | |\n | Cursor +--->+ DBHub +--->+ SQL Server |\n | | | | | |\n | Other Clients +--->+ +--->+ SQLite |\n | | | | | |\n | | | +--->+ MySQL |\n | | | | | |\n | | | +--->+ MariaDB |\n | | | | | |\n +------------------+ +--------------+ +------------------+\n MCP Clients MCP Server Databases\n```\n\n## Demo HTTP Endpoint\n\nhttps://demo.dbhub.ai/message connects a [sample employee database](https://github.com/bytebase/employee-sample-database). You can point Cursor or MCP Inspector to it to see it in action.\n\n![mcp-inspector](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/mcp-inspector.webp)\n\n## Supported Matrix\n\n### Database Resources\n\n| Resource Name | URI Format | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite |\n| --------------------------- | ------------------------------------------------------ | :--------: | :---: | :-----: | :--------: | :----: |\n| schemas | `db://schemas` | ✅ | ✅ | ✅ | ✅ | ✅ |\n| tables_in_schema | `db://schemas/{schemaName}/tables` | ✅ | ✅ | ✅ | ✅ | ✅ |\n| table_structure_in_schema | `db://schemas/{schemaName}/tables/{tableName}` | ✅ | ✅ | ✅ | ✅ | ✅ |\n| indexes_in_table | `db://schemas/{schemaName}/tables/{tableName}/indexes` | ✅ | ✅ | ✅ | ✅ | ✅ |\n| procedures_in_schema | `db://schemas/{schemaName}/procedures` | ✅ | ✅ | ✅ | ✅ | ❌ |\n| procedure_details_in_schema | `db://schemas/{schemaName}/procedures/{procedureName}` | ✅ | ✅ | ✅ | ✅ | ❌ |\n\n### Database Tools\n\n| Tool | Command Name | Description | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite |\n| ----------- | ------------- | ------------------------------------------------------------------- | :--------: | :---: | :-----: | :--------: | ------ |\n| Execute SQL | `execute_sql` | Execute single or multiple SQL statements (separated by semicolons) | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n### Prompt Capabilities\n\n| Prompt | Command Name | PostgreSQL | MySQL | MariaDB | SQL Server | SQLite |\n| ------------------- | -------------- | :--------: | :---: | :-----: | :--------: | ------ |\n| Generate SQL | `generate_sql` | ✅ | ✅ | ✅ | ✅ | ✅ |\n| Explain DB Elements | `explain_db` | ✅ | ✅ | ✅ | ✅ | ✅ |\n\n## Installation\n\n### Docker\n\n```bash\n# PostgreSQL example\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```bash\n# Demo mode with sqlite sample employee database\ndocker run --rm --init \\\n --name dbhub \\\n --publish 8080:8080 \\\n bytebase/dbhub \\\n --transport http \\\n --port 8080 \\\n --demo\n```\n\n\n### NPM\n\n```bash\n# PostgreSQL example\nnpx @bytebase/dbhub --transport http --port 8080 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n\n# Demo mode with sqlite sample employee database\nnpx @bytebase/dbhub --transport http --port 8080 --demo\n```\n\n```bash\n# Demo mode with sample employee database\nnpx @bytebase/dbhub --transport http --port 8080 --demo\n```\n\n> Note: The demo mode includes a bundled SQLite sample \"employee\" database with tables for employees, departments, salaries, and more.\n\n### Claude Desktop\n\n![claude-desktop](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/claude-desktop.webp)\n\n- Claude Desktop only supports `stdio` transport https://github.com/orgs/modelcontextprotocol/discussions/16\n\n```json\n// claude_desktop_config.json\n{\n \"mcpServers\": {\n \"dbhub-postgres-docker\": {\n \"command\": \"docker\",\n \"args\": [\n \"run\",\n \"-i\",\n \"--rm\",\n \"bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n // Use host.docker.internal as the host if connecting to the local db\n \"postgres://user:password@host.docker.internal:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-postgres-npx\": {\n \"command\": \"npx\",\n \"args\": [\n \"-y\",\n \"@bytebase/dbhub\",\n \"--transport\",\n \"stdio\",\n \"--dsn\",\n \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ]\n },\n \"dbhub-demo\": {\n \"command\": \"npx\",\n \"args\": [\"-y\", \"@bytebase/dbhub\", \"--transport\", \"stdio\", \"--demo\"]\n }\n }\n}\n```\n\n### Cursor\n\n[![Install MCP Server](https://cursor.com/deeplink/mcp-install-dark.svg)](https://cursor.com/install-mcp?name=dbhub&config=eyJjb21tYW5kIjoibnB4IEBieXRlYmFzZS9kYmh1YiIsImVudiI6eyJUUkFOU1BPUlQiOiJzdGRpbyIsIkRTTiI6InBvc3RncmVzOi8vdXNlcjpwYXNzd29yZEBsb2NhbGhvc3Q6NTQzMi9kYm5hbWU%2Fc3NsbW9kZT1kaXNhYmxlIiwiUkVBRE9OTFkiOiJ0cnVlIn19)\n\n![cursor](https://raw.githubusercontent.com/bytebase/dbhub/main/resources/images/cursor.webp)\n\n- Cursor supports both `stdio` and `http`.\n- Follow [Cursor MCP guide](https://docs.cursor.com/context/model-context-protocol) and make sure to use [Agent](https://docs.cursor.com/chat/agent) mode.\n\n## Usage\n\n### SSL Connections\n\nYou can specify the SSL mode using the `sslmode` parameter in your DSN string:\n\n| Database | `sslmode=disable` | `sslmode=require` | Default SSL Behavior |\n| ---------- | :---------------: | :---------------: | :----------------------------: |\n| PostgreSQL | ✅ | ✅ | Certificate verification |\n| MySQL | ✅ | ✅ | Certificate verification |\n| MariaDB | ✅ | ✅ | Certificate verification |\n| SQL Server | ✅ | ✅ | Certificate verification |\n| SQLite | ❌ | ❌ | N/A (file-based) |\n\n**SSL Mode Options:**\n\n- `sslmode=disable`: All SSL/TLS encryption is turned off. Data is transmitted in plaintext.\n- `sslmode=require`: Connection is encrypted, but the server's certificate is not verified. This provides protection against packet sniffing but not against man-in-the-middle attacks. You may use this for trusted self-signed CA.\n\nWithout specifying `sslmode`, most databases default to certificate verification, which provides the highest level of security.\n\nExample usage:\n\n```bash\n# Disable SSL\npostgres://user:password@localhost:5432/dbname?sslmode=disable\n\n# Require SSL without certificate verification\npostgres://user:password@localhost:5432/dbname?sslmode=require\n\n# Standard SSL with certificate verification (default)\npostgres://user:password@localhost:5432/dbname\n```\n\n### Read-only Mode\n\nYou can run DBHub in read-only mode, which restricts SQL query execution to read-only operations:\n\n```bash\n# Enable read-only mode\nnpx @bytebase/dbhub --readonly --dsn \"postgres://user:password@localhost:5432/dbname\"\n```\n\nIn read-only mode, only [readonly SQL operations](https://github.com/bytebase/dbhub/blob/main/src/utils/allowed-keywords.ts) are allowed.\n\nThis provides an additional layer of security when connecting to production databases.\n\n### Configure your database connection\n\nYou can use DBHub in demo mode with a sample employee database for testing:\n\n```bash\nnpx @bytebase/dbhub --demo\n```\n\n> [!WARNING]\n> If your user/password contains special characters, you need to escape them first. (e.g. `pass#word` should be escaped as `pass%23word`)\n\nFor real databases, a Database Source Name (DSN) is required. You can provide this in several ways:\n\n- **Command line argument** (highest priority):\n\n ```bash\n npx @bytebase/dbhub --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n- **Environment variable** (second priority):\n\n ```bash\n export DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n npx @bytebase/dbhub\n ```\n\n- **Environment file** (third priority):\n - For development: Create `.env.local` with your DSN\n - For production: Create `.env` with your DSN\n ```\n DSN=postgres://user:password@localhost:5432/dbname?sslmode=disable\n ```\n\n> [!WARNING]\n> When running in Docker, use `host.docker.internal` instead of `localhost` to connect to databases running on your host machine. For example: `mysql://user:password@host.docker.internal:3306/dbname`\n\nDBHub supports the following database connection string formats:\n\n| Database | DSN Format | Example |\n| ---------- | --------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------- |\n| MySQL | `mysql://[user]:[password]@[host]:[port]/[database]` | `mysql://user:password@localhost:3306/dbname?sslmode=disable` |\n| MariaDB | `mariadb://[user]:[password]@[host]:[port]/[database]` | `mariadb://user:password@localhost:3306/dbname?sslmode=disable` |\n| PostgreSQL | `postgres://[user]:[password]@[host]:[port]/[database]` | `postgres://user:password@localhost:5432/dbname?sslmode=disable` |\n| SQL Server | `sqlserver://[user]:[password]@[host]:[port]/[database]` | `sqlserver://user:password@localhost:1433/dbname?sslmode=disable` |\n| SQLite | `sqlite:///[path/to/file]` or `sqlite:///:memory:` | `sqlite:///path/to/database.db`, `sqlite:C:/Users/YourName/data/database.db (windows)` or `sqlite:///:memory:` |\n\n\n#### SQL Server\n\nExtra query parameters:\n\n#### authentication\n\n- `authentication=azure-active-directory-access-token`. Only applicable when running from Azure. See [DefaultAzureCredential](https://learn.microsoft.com/en-us/azure/developer/javascript/sdk/authentication/credential-chains#use-defaultazurecredential-for-flexibility).\n\n### Transport\n\n- **stdio** (default) - for direct integration with tools like Claude Desktop:\n\n ```bash\n npx @bytebase/dbhub --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n- **http** - for browser and network clients:\n ```bash\n npx @bytebase/dbhub --transport http --port 5678 --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Command line options\n\n| Option | Environment Variable | Description | Default |\n| --------- | -------------------- | ---------------------------------------------------------------- | ---------------------------- |\n| dsn | `DSN` | Database connection string | Required if not in demo mode |\n| transport | `TRANSPORT` | Transport mode: `stdio` or `http` | `stdio` |\n| port | `PORT` | HTTP server port (only applicable when using `--transport=http`) | `8080` |\n| readonly | `READONLY` | Restrict SQL execution to read-only operations | `false` |\n| demo | N/A | Run in demo mode with sample employee database | `false` |\n\nThe demo mode uses an in-memory SQLite database loaded with the [sample employee database](https://github.com/bytebase/dbhub/tree/main/resources/employee-sqlite) that includes tables for employees, departments, titles, salaries, department employees, and department managers. The sample database includes SQL scripts for table creation, data loading, and testing.\n\n## Development\n\n1. Install dependencies:\n\n ```bash\n pnpm install\n ```\n\n1. Run in development mode:\n\n ```bash\n pnpm dev\n ```\n\n1. Build for production:\n ```bash\n pnpm build\n pnpm start --transport stdio --dsn \"postgres://user:password@localhost:5432/dbname?sslmode=disable\"\n ```\n\n### Testing\n\nThe project uses Vitest for comprehensive unit and integration testing:\n\n- **Run all tests**: `pnpm test`\n- **Run tests in watch mode**: `pnpm test:watch`\n- **Run integration tests**: `pnpm test:integration`\n\n#### Integration Tests\n\nDBHub includes comprehensive integration tests for all supported database connectors using [Testcontainers](https://testcontainers.com/). These tests run against real database instances in Docker containers, ensuring full compatibility and feature coverage.\n\n##### Prerequisites\n\n- **Docker**: Ensure Docker is installed and running on your machine\n- **Docker Resources**: Allocate sufficient memory (recommended: 4GB+) for multiple database containers\n- **Network Access**: Ability to pull Docker images from registries\n\n##### Running Integration Tests\n\n**Note**: This command runs all integration tests in parallel, which may take 5-15 minutes depending on your system resources and network speed.\n\n```bash\n# Run all database integration tests\npnpm test:integration\n```\n\n```bash\n# Run only PostgreSQL integration tests\npnpm test src/connectors/__tests__/postgres.integration.test.ts\n# Run only MySQL integration tests\npnpm test src/connectors/__tests__/mysql.integration.test.ts\n# Run only MariaDB integration tests\npnpm test src/connectors/__tests__/mariadb.integration.test.ts\n# Run only SQL Server integration tests\npnpm test src/connectors/__tests__/sqlserver.integration.test.ts\n# Run only SQLite integration tests\npnpm test src/connectors/__tests__/sqlite.integration.test.ts\n# Run JSON RPC integration tests\npnpm test src/__tests__/json-rpc-integration.test.ts\n```\n\nAll integration tests follow these patterns:\n\n1. **Container Lifecycle**: Start database container → Connect → Setup test data → Run tests → Cleanup\n2. **Shared Test Utilities**: Common test patterns implemented in `IntegrationTestBase` class\n3. **Database-Specific Features**: Each database includes tests for unique features and capabilities\n4. **Error Handling**: Comprehensive testing of connection errors, invalid SQL, and edge cases\n\n##### Troubleshooting Integration Tests\n\n**Container Startup Issues:**\n\n```bash\n# Check Docker is running\ndocker ps\n\n# Check available memory\ndocker system df\n\n# Pull images manually if needed\ndocker pull postgres:15-alpine\ndocker pull mysql:8.0\ndocker pull mariadb:10.11\ndocker pull mcr.microsoft.com/mssql/server:2019-latest\n```\n\n**SQL Server Timeout Issues:**\n\n- SQL Server containers require significant startup time (3-5 minutes)\n- Ensure Docker has sufficient memory allocated (4GB+ recommended)\n- Consider running SQL Server tests separately if experiencing timeouts\n\n\n**Network/Resource Issues:**\n\n```bash\n# Run tests with verbose output\npnpm test:integration --reporter=verbose\n\n# Run single database test to isolate issues\npnpm test:integration -- --testNamePattern=\"PostgreSQL\"\n\n# Check Docker container logs if tests fail\ndocker logs \n```\n\n#### Pre-commit Hooks (for Developers)\n\nThe project includes pre-commit hooks to run tests automatically before each commit:\n\n1. After cloning the repository, set up the pre-commit hooks:\n\n ```bash\n ./scripts/setup-husky.sh\n ```\n\n2. This ensures the test suite runs automatically whenever you create a commit, preventing commits that would break tests.\n\n### Debug with [MCP Inspector](https://github.com/modelcontextprotocol/inspector)\n\n#### stdio\n\n```bash\n# PostgreSQL example\nTRANSPORT=stdio DSN=\"postgres://user:password@localhost:5432/dbname?sslmode=disable\" npx @modelcontextprotocol/inspector node /path/to/dbhub/dist/index.js\n```\n\n#### HTTP\n\n```bash\n# Start DBHub with HTTP transport\npnpm dev --transport=http --port=8080\n\n# Start the MCP Inspector in another terminal\nnpx @modelcontextprotocol/inspector\n```\n\nConnect to the DBHub server `/message` endpoint\n\n## Contributors\n\n\n

\n\n\n## Star History\n\n[![Star History Chart](https://api.star-history.com/svg?repos=bytebase/dbhub&type=Date)](https://www.star-history.com/#bytebase/dbhub&Date)\n","url","https://github.com/bytebase/dbhub","githubRepository",{"_120":121,"_122":123,"_124":125,"_126":127,"_33":128,"_129":130,"_135":136,"_137":138,"_140":141},"defaultBranch","main","fullName","bytebase/dbhub","githubTreeId",129196,"language","TypeScript","dbhub","owner",{"_131":132,"_133":134},"login","bytebase","uid","UWFsBLvgaC","recentStargazers",68,"spdxLicense",{"_33":139},"MIT License","stargazers",762,"glamaJson",1813,"inspectable",false,"integrations",[148,158,165,172,179],{"_149":150,"_31":156,"_133":157},"brand",{"_151":152,"_33":153,"_154":155},"logoSvgPath","M13.983 11.078h2.119a.186.186 0 00.186-.185V9.006a.186.186 0 00-.186-.186h-2.119a.185.185 0 00-.185.185v1.888c0 .102.083.185.185.185m-2.954-5.43h2.118a.186.186 0 00.186-.186V3.574a.186.186 0 00-.186-.185h-2.118a.185.185 0 00-.185.185v1.888c0 .102.082.185.185.185m0 2.716h2.118a.187.187 0 00.186-.186V6.29a.186.186 0 00-.186-.185h-2.118a.185.185 0 00-.185.185v1.887c0 .102.082.185.185.186m-2.93 0h2.12a.186.186 0 00.184-.186V6.29a.185.185 0 00-.185-.185H8.1a.185.185 0 00-.185.185v1.887c0 .102.083.185.185.186m-2.964 0h2.119a.186.186 0 00.185-.186V6.29a.185.185 0 00-.185-.185H5.136a.186.186 0 00-.186.185v1.887c0 .102.084.185.186.186m5.893 2.715h2.118a.186.186 0 00.186-.185V9.006a.186.186 0 00-.186-.186h-2.118a.185.185 0 00-.185.185v1.888c0 .102.082.185.185.185m-2.93 0h2.12a.185.185 0 00.184-.185V9.006a.185.185 0 00-.184-.186h-2.12a.185.185 0 00-.184.185v1.888c0 .102.083.185.185.185m-2.964 0h2.119a.185.185 0 00.185-.185V9.006a.185.185 0 00-.184-.186h-2.12a.186.186 0 00-.186.186v1.887c0 .102.084.185.186.185m-2.92 0h2.12a.185.185 0 00.184-.185V9.006a.185.185 0 00-.184-.186h-2.12a.185.185 0 00-.184.185v1.888c0 .102.082.185.185.185M23.763 9.89c-.065-.051-.672-.51-1.954-.51-.338.001-.676.03-1.01.087-.248-1.7-1.653-2.53-1.716-2.566l-.344-.199-.226.327c-.284.438-.49.922-.612 1.43-.23.97-.09 1.882.403 2.661-.595.332-1.55.413-1.744.42H.751a.751.751 0 00-.75.748 11.376 11.376 0 00.692 4.062c.545 1.428 1.355 2.48 2.41 3.124 1.18.723 3.1 1.137 5.275 1.137.983.003 1.963-.086 2.93-.266a12.248 12.248 0 003.823-1.389c.98-.567 1.86-1.288 2.61-2.136 1.252-1.418 1.998-2.997 2.553-4.4h.221c1.372 0 2.215-.549 2.68-1.009.309-.293.55-.65.707-1.046l.098-.288Z","Docker","slug","docker","Provides Docker container deployment options for running the DBHub server with configurable database connections and transport options.","lh19wbd76u",{"_149":159,"_31":163,"_133":164},{"_151":160,"_33":161,"_154":162},"M12 0C5.363 0 0 5.363 0 12s5.363 12 12 12 12-5.363 12-12S18.637 0 12 0zM9.502 7.03a4.974 4.974 0 0 1 4.97 4.97 4.974 4.974 0 0 1-4.97 4.97A4.974 4.974 0 0 1 4.532 12a4.974 4.974 0 0 1 4.97-4.97zm6.563 3.183h2.351c.98 0 1.787.782 1.787 1.762s-.807 1.789-1.787 1.789h-2.351v-3.551z","DuckDB","duckdb","Supports connecting to DuckDB databases to explore tables, access schema information, and perform read-only SQL queries with safety measures.","5bmwwpyhx2",{"_149":166,"_31":170,"_133":171},{"_151":167,"_33":168,"_154":169},"M16.405 5.501c-.115 0-.193.014-.274.033v.013h.014c.054.104.146.18.214.273.054.107.1.214.154.32l.014-.015c.094-.066.14-.172.14-.333-.04-.047-.046-.094-.08-.14-.04-.067-.126-.1-.18-.153zM5.77 18.695h-.927a50.854 50.854 0 00-.27-4.41h-.008l-1.41 4.41H2.45l-1.4-4.41h-.01a72.892 72.892 0 00-.195 4.41H0c.055-1.966.192-3.81.41-5.53h1.15l1.335 4.064h.008l1.347-4.064h1.095c.242 2.015.384 3.86.428 5.53zm4.017-4.08c-.378 2.045-.876 3.533-1.492 4.46-.482.716-1.01 1.073-1.583 1.073-.153 0-.34-.046-.566-.138v-.494c.11.017.24.026.386.026.268 0 .483-.075.647-.222.197-.18.295-.382.295-.605 0-.155-.077-.47-.23-.944L6.23 14.615h.91l.727 2.36c.164.536.233.91.205 1.123.4-1.064.678-2.227.835-3.483zm12.325 4.08h-2.63v-5.53h.885v4.85h1.745zm-3.32.135l-1.016-.5c.09-.076.177-.158.255-.25.433-.506.648-1.258.648-2.253 0-1.83-.718-2.746-2.155-2.746-.704 0-1.254.232-1.65.697-.43.508-.646 1.256-.646 2.245 0 .972.19 1.686.574 2.14.35.41.877.615 1.583.615.264 0 .506-.033.725-.098l1.325.772.36-.622zM15.5 17.588c-.225-.36-.337-.94-.337-1.736 0-1.393.424-2.09 1.27-2.09.443 0 .77.167.977.5.224.362.336.936.336 1.723 0 1.404-.424 2.108-1.27 2.108-.445 0-.77-.167-.978-.5zm-1.658-.425c0 .47-.172.856-.516 1.156-.344.3-.803.45-1.384.45-.543 0-1.064-.172-1.573-.515l.237-.476c.438.22.833.328 1.19.328.332 0 .593-.073.783-.22a.754.754 0 00.3-.615c0-.33-.23-.61-.648-.845-.388-.213-1.163-.657-1.163-.657-.422-.307-.632-.636-.632-1.177 0-.45.157-.81.47-1.085.315-.278.72-.415 1.22-.415.512 0 .98.136 1.4.41l-.213.476a2.726 2.726 0 00-1.064-.23c-.283 0-.502.068-.654.206a.685.685 0 00-.248.524c0 .328.234.61.666.85.393.215 1.187.67 1.187.67.433.305.648.63.648 1.168zm9.382-5.852c-.535-.014-.95.04-1.297.188-.1.04-.26.04-.274.167.055.053.063.14.11.214.08.134.218.313.346.407.14.11.28.216.427.31.26.16.555.255.81.416.145.094.293.213.44.313.073.05.12.14.214.172v-.02c-.046-.06-.06-.147-.105-.214-.067-.067-.134-.127-.2-.193a3.223 3.223 0 00-.695-.675c-.214-.146-.682-.35-.77-.595l-.013-.014c.146-.013.32-.066.46-.106.227-.06.435-.047.67-.106.106-.027.213-.06.32-.094v-.06c-.12-.12-.21-.283-.334-.395a8.867 8.867 0 00-1.104-.823c-.21-.134-.476-.22-.697-.334-.08-.04-.214-.06-.26-.127-.12-.146-.19-.34-.275-.514a17.69 17.69 0 01-.547-1.163c-.12-.262-.193-.523-.34-.763-.69-1.137-1.437-1.826-2.586-2.5-.247-.14-.543-.2-.856-.274-.167-.008-.334-.02-.5-.027-.11-.047-.216-.174-.31-.235-.38-.24-1.364-.76-1.644-.072-.18.434.267.862.422 1.082.115.153.26.328.34.5.047.116.06.235.107.356.106.294.207.622.347.897.073.14.153.287.247.413.054.073.146.107.167.227-.094.136-.1.334-.154.5-.24.757-.146 1.693.194 2.25.107.166.362.534.703.393.3-.12.234-.5.32-.835.02-.08.007-.133.048-.187v.015c.094.188.188.367.274.555.206.328.566.668.867.895.16.12.287.328.487.402v-.02h-.015c-.043-.058-.1-.086-.154-.133a3.445 3.445 0 01-.35-.4 8.76 8.76 0 01-.747-1.218c-.11-.21-.202-.436-.29-.643-.04-.08-.04-.2-.107-.24-.1.146-.247.273-.32.453-.127.288-.14.642-.188 1.01-.027.007-.014 0-.027.014-.214-.052-.287-.274-.367-.46-.2-.475-.233-1.238-.06-1.785.047-.14.247-.582.167-.716-.042-.127-.174-.2-.247-.303a2.478 2.478 0 01-.24-.427c-.16-.374-.24-.788-.414-1.162-.08-.173-.22-.354-.334-.513-.127-.18-.267-.307-.368-.52-.033-.073-.08-.194-.027-.274.014-.054.042-.075.094-.09.088-.072.335.022.422.062.247.1.455.194.662.334.094.066.195.193.315.226h.14c.214.047.455.014.655.073.355.114.675.28.962.46a5.953 5.953 0 012.085 2.286c.08.154.115.295.188.455.14.33.313.663.455.982.14.315.275.636.476.897.1.14.502.213.682.286.133.06.34.115.46.188.23.14.454.3.67.454.11.076.443.243.463.378z","MySQL","mysql","Provides access to MySQL databases for browsing tables, viewing schema information, and executing read-only SQL queries with safety protections.","c07wfbv331",{"_149":173,"_31":177,"_133":178},{"_151":174,"_33":175,"_154":176},"M23.5594 14.7228a.5269.5269 0 0 0-.0563-.1191c-.139-.2632-.4768-.3418-1.0074-.2321-1.6533.3411-2.2935.1312-2.5256-.0191 1.342-2.0482 2.445-4.522 3.0411-6.8297.2714-1.0507.7982-3.5237.1222-4.7316a1.5641 1.5641 0 0 0-.1509-.235C21.6931.9086 19.8007.0248 17.5099.0005c-1.4947-.0158-2.7705.3461-3.1161.4794a9.449 9.449 0 0 0-.5159-.0816 8.044 8.044 0 0 0-1.3114-.1278c-1.1822-.0184-2.2038.2642-3.0498.8406-.8573-.3211-4.7888-1.645-7.2219.0788C.9359 2.1526.3086 3.8733.4302 6.3043c.0409.818.5069 3.334 1.2423 5.7436.4598 1.5065.9387 2.7019 1.4334 3.582.553.9942 1.1259 1.5933 1.7143 1.7895.4474.1491 1.1327.1441 1.8581-.7279.8012-.9635 1.5903-1.8258 1.9446-2.2069.4351.2355.9064.3625 1.39.3772a.0569.0569 0 0 0 .0004.0041 11.0312 11.0312 0 0 0-.2472.3054c-.3389.4302-.4094.5197-1.5002.7443-.3102.064-1.1344.2339-1.1464.8115-.0025.1224.0329.2309.0919.3268.2269.4231.9216.6097 1.015.6331 1.3345.3335 2.5044.092 3.3714-.6787-.017 2.231.0775 4.4174.3454 5.0874.2212.5529.7618 1.9045 2.4692 1.9043.2505 0 .5263-.0291.8296-.0941 1.7819-.3821 2.5557-1.1696 2.855-2.9059.1503-.8707.4016-2.8753.5388-4.1012.0169-.0703.0357-.1207.057-.1362.0007-.0005.0697-.0471.4272.0307a.3673.3673 0 0 0 .0443.0068l.2539.0223.0149.001c.8468.0384 1.9114-.1426 2.5312-.4308.6438-.2988 1.8057-1.0323 1.5951-1.6698zM2.371 11.8765c-.7435-2.4358-1.1779-4.8851-1.2123-5.5719-.1086-2.1714.4171-3.6829 1.5623-4.4927 1.8367-1.2986 4.8398-.5408 6.108-.13-.0032.0032-.0066.0061-.0098.0094-2.0238 2.044-1.9758 5.536-1.9708 5.7495-.0002.0823.0066.1989.0162.3593.0348.5873.0996 1.6804-.0735 2.9184-.1609 1.1504.1937 2.2764.9728 3.0892.0806.0841.1648.1631.2518.2374-.3468.3714-1.1004 1.1926-1.9025 2.1576-.5677.6825-.9597.5517-1.0886.5087-.3919-.1307-.813-.5871-1.2381-1.3223-.4796-.839-.9635-2.0317-1.4155-3.5126zm6.0072 5.0871c-.1711-.0428-.3271-.1132-.4322-.1772.0889-.0394.2374-.0902.4833-.1409 1.2833-.2641 1.4815-.4506 1.9143-1.0002.0992-.126.2116-.2687.3673-.4426a.3549.3549 0 0 0 .0737-.1298c.1708-.1513.2724-.1099.4369-.0417.156.0646.3078.26.3695.4752.0291.1016.0619.2945-.0452.4444-.9043 1.2658-2.2216 1.2494-3.1676 1.0128zm2.094-3.988-.0525.141c-.133.3566-.2567.6881-.3334 1.003-.6674-.0021-1.3168-.2872-1.8105-.8024-.6279-.6551-.9131-1.5664-.7825-2.5004.1828-1.3079.1153-2.4468.079-3.0586-.005-.0857-.0095-.1607-.0122-.2199.2957-.2621 1.6659-.9962 2.6429-.7724.4459.1022.7176.4057.8305.928.5846 2.7038.0774 3.8307-.3302 4.7363-.084.1866-.1633.3629-.2311.5454zm7.3637 4.5725c-.0169.1768-.0358.376-.0618.5959l-.146.4383a.3547.3547 0 0 0-.0182.1077c-.0059.4747-.054.6489-.115.8693-.0634.2292-.1353.4891-.1794 1.0575-.11 1.4143-.8782 2.2267-2.4172 2.5565-1.5155.3251-1.7843-.4968-2.0212-1.2217a6.5824 6.5824 0 0 0-.0769-.2266c-.2154-.5858-.1911-1.4119-.1574-2.5551.0165-.5612-.0249-1.9013-.3302-2.6462.0044-.2932.0106-.5909.019-.8918a.3529.3529 0 0 0-.0153-.1126 1.4927 1.4927 0 0 0-.0439-.208c-.1226-.4283-.4213-.7866-.7797-.9351-.1424-.059-.4038-.1672-.7178-.0869.067-.276.1831-.5875.309-.9249l.0529-.142c.0595-.16.134-.3257.213-.5012.4265-.9476 1.0106-2.2453.3766-5.1772-.2374-1.0981-1.0304-1.6343-2.2324-1.5098-.7207.0746-1.3799.3654-1.7088.5321a5.6716 5.6716 0 0 0-.1958.1041c.0918-1.1064.4386-3.1741 1.7357-4.4823a4.0306 4.0306 0 0 1 .3033-.276.3532.3532 0 0 0 .1447-.0644c.7524-.5706 1.6945-.8506 2.802-.8325.4091.0067.8017.0339 1.1742.081 1.939.3544 3.2439 1.4468 4.0359 2.3827.8143.9623 1.2552 1.9315 1.4312 2.4543-1.3232-.1346-2.2234.1268-2.6797.779-.9926 1.4189.543 4.1729 1.2811 5.4964.1353.2426.2522.4522.2889.5413.2403.5825.5515.9713.7787 1.2552.0696.087.1372.1714.1885.245-.4008.1155-1.1208.3825-1.0552 1.717-.0123.1563-.0423.4469-.0834.8148-.0461.2077-.0702.4603-.0994.7662zm.8905-1.6211c-.0405-.8316.2691-.9185.5967-1.0105a2.8566 2.8566 0 0 0 .135-.0406 1.202 1.202 0 0 0 .1342.103c.5703.3765 1.5823.4213 3.0068.1344-.2016.1769-.5189.3994-.9533.6011-.4098.1903-1.0957.333-1.7473.3636-.7197.0336-1.0859-.0807-1.1721-.151zm.5695-9.2712c-.0059.3508-.0542.6692-.1054 1.0017-.055.3576-.112.7274-.1264 1.1762-.0142.4368.0404.8909.0932 1.3301.1066.887.216 1.8003-.2075 2.7014a3.5272 3.5272 0 0 1-.1876-.3856c-.0527-.1276-.1669-.3326-.3251-.6162-.6156-1.1041-2.0574-3.6896-1.3193-4.7446.3795-.5427 1.3408-.5661 2.1781-.463zm.2284 7.0137a12.3762 12.3762 0 0 0-.0853-.1074l-.0355-.0444c.7262-1.1995.5842-2.3862.4578-3.4385-.0519-.4318-.1009-.8396-.0885-1.2226.0129-.4061.0666-.7543.1185-1.0911.0639-.415.1288-.8443.1109-1.3505.0134-.0531.0188-.1158.0118-.1902-.0457-.4855-.5999-1.938-1.7294-3.253-.6076-.7073-1.4896-1.4972-2.6889-2.0395.5251-.1066 1.2328-.2035 2.0244-.1859 2.0515.0456 3.6746.8135 4.8242 2.2824a.908.908 0 0 1 .0667.1002c.7231 1.3556-.2762 6.2751-2.9867 10.5405zm-8.8166-6.1162c-.025.1794-.3089.4225-.6211.4225a.5821.5821 0 0 1-.0809-.0056c-.1873-.026-.3765-.144-.5059-.3156-.0458-.0605-.1203-.178-.1055-.2844.0055-.0401.0261-.0985.0925-.1488.1182-.0894.3518-.1226.6096-.0867.3163.0441.6426.1938.6113.4186zm7.9305-.4114c.0111.0792-.049.201-.1531.3102-.0683.0717-.212.1961-.4079.2232a.5456.5456 0 0 1-.075.0052c-.2935 0-.5414-.2344-.5607-.3717-.024-.1765.2641-.3106.5611-.352.297-.0414.6111.0088.6356.1851z","PostgreSQL","postgresql","Allows querying PostgreSQL databases, browsing tables, viewing schema information, and running read-only SQL queries with safety checks.","kqjzrgdjpv",{"_149":180,"_31":184,"_133":185},{"_151":181,"_33":182,"_154":183},"M21.678.521c-1.032-.92-2.28-.55-3.513.544a8.71 8.71 0 0 0-.547.535c-2.109 2.237-4.066 6.38-4.674 9.544.237.48.422 1.093.544 1.561a13.044 13.044 0 0 1 .164.703s-.019-.071-.096-.296l-.05-.146a1.689 1.689 0 0 0-.033-.08c-.138-.32-.518-.995-.686-1.289-.143.423-.27.818-.376 1.176.484.884.778 2.4.778 2.4s-.025-.099-.147-.442c-.107-.303-.644-1.244-.772-1.464-.217.804-.304 1.346-.226 1.478.152.256.296.698.422 1.186.286 1.1.485 2.44.485 2.44l.017.224a22.41 22.41 0 0 0 .056 2.748c.095 1.146.273 2.13.5 2.657l.155-.084c-.334-1.038-.47-2.399-.41-3.967.09-2.398.642-5.29 1.661-8.304 1.723-4.55 4.113-8.201 6.3-9.945-1.993 1.8-4.692 7.63-5.5 9.788-.904 2.416-1.545 4.684-1.931 6.857.666-2.037 2.821-2.912 2.821-2.912s1.057-1.304 2.292-3.166c-.74.169-1.955.458-2.362.629-.6.251-.762.337-.762.337s1.945-1.184 3.613-1.72C21.695 7.9 24.195 2.767 21.678.521m-18.573.543A1.842 1.842 0 0 0 1.27 2.9v16.608a1.84 1.84 0 0 0 1.835 1.834h9.418a22.953 22.953 0 0 1-.052-2.707c-.006-.062-.011-.141-.016-.2a27.01 27.01 0 0 0-.473-2.378c-.121-.47-.275-.898-.369-1.057-.116-.197-.098-.31-.097-.432 0-.12.015-.245.037-.386a9.98 9.98 0 0 1 .234-1.045l.217-.028c-.017-.035-.014-.065-.031-.097l-.041-.381a32.8 32.8 0 0 1 .382-1.194l.2-.019c-.008-.016-.01-.038-.018-.053l-.043-.316c.63-3.28 2.587-7.443 4.8-9.791.066-.069.133-.128.198-.194Z","SQLite","sqlite","Enables connection to SQLite databases to browse available tables, view schema information, and run protected read-only SQL queries.","d3jv4dgcao","namespace","npmPackage",{"_33":128,"_189":190},"weeklyDownloads",2,"prompts","redditPostForeignId","1jbqtpg","resources","scores",{"_197":198,"_199":-5,"_200":-5},"license",100,"quality","security","simpleIcon","supportedPlatforms",[204,205,206],"WINDOWS","LINUX","MACOS","tools","a01xnguu8x","updatedAt","2025-06-26T11:43:12.892892389Z","meta",[213,216,218,225,228,230,233,236,239,242,245,247,250,253,255,257,259,261,263],{"_214":215},"title","DBHub | Glama",{"_217":42,"_33":31},"content",{"_219":220,"_221":222,"_223":224},"href","https://glama.ai/mcp/servers/@bytebase/dbhub","rel","canonical","tagName","link",{"_217":34,"_226":227},"property","og:title",{"_217":42,"_226":229},"og:description",{"_217":231,"_226":232},"https://glama.ai/logo.png","og:logo",{"_217":234,"_226":235},"https://glama.ai/mcp/servers/@bytebase/dbhub/og-image","og:image",{"_217":237,"_226":238},"630","og:image:height",{"_217":240,"_226":241},"1200","og:image:width",{"_217":243,"_226":244},"website","og:type",{"_217":220,"_226":246},"og:url",{"_217":248,"_226":249},"Glama – MCP Hosting Platform","og:site_name",{"_217":251,"_33":252},"summary_large_image","twitter:card",{"_217":248,"_33":254},"twitter:title",{"_217":42,"_33":256},"twitter:description",{"_217":234,"_33":258},"twitter:image",{"_217":237,"_33":260},"twitter:image:height",{"_217":240,"_33":262},"twitter:image:width",{"_264":265},"script:ld+json",{"_266":267,"_268":269},"@context","http://schema.org","@graph",[270],{"_266":271,"_272":273,"_274":275},"https://schema.org","@type","BreadcrumbList","itemListElement",[276,283,286,290],{"_272":277,"_278":279,"_33":280,"_281":282},"ListItem","item","https://glama.ai/","Glama","position",1,{"_272":277,"_278":284,"_33":285,"_281":190},"https://glama.ai/mcp","MCP",{"_272":277,"_278":287,"_33":288,"_281":289},"https://glama.ai/mcp/servers","Servers",3,{"_272":277,"_278":220,"_33":34,"_281":291},4,"visitorIsMaintainer","routes/_public/mcp/servers/~namespace/~slug/_pages/_explorer/blob/~branch/~/_route",{"_295":296,"_300":121,"_29":301,"_211":327,"_351":352,"_353":354},"blob",{"_217":297,"_298":299},"# Skip husky install when installing in CI or production environments\nignore-scripts=false\nengine-strict=true\nhoist=true\nenable-pre-post-scripts=true\nauto-install-peers=true","fileName",".npmrc","branch",{"_81":82,"_83":302,"_13":308,"_111":42,"_112":42,"_113":309,"_118":310,"_142":-5,"_16":143,"_144":145,"_146":313,"_33":34,"_186":132,"_187":324,"_191":-5,"_192":193,"_194":-5,"_195":325,"_201":-5,"_154":128,"_202":326,"_207":-5,"_133":208,"_209":210},{"_85":303,"_101":307,"_90":103},{"_87":304,"_92":305,"_97":306},{"_31":89,"_90":91},{"_94":95,"_31":96,"_90":91},{"_94":99,"_31":100,"_90":91},[87],[105,106,107,108,109,110],{"_35":115,"_116":117},{"_120":121,"_122":123,"_124":125,"_126":127,"_33":128,"_129":311,"_135":136,"_137":312,"_140":141},{"_131":132,"_133":134},{"_33":139},[314,316,318,320,322],{"_149":315,"_31":156,"_133":157},{"_151":152,"_33":153,"_154":155},{"_149":317,"_31":163,"_133":164},{"_151":160,"_33":161,"_154":162},{"_149":319,"_31":170,"_133":171},{"_151":167,"_33":168,"_154":169},{"_149":321,"_31":177,"_133":178},{"_151":174,"_33":175,"_154":176},{"_149":323,"_31":184,"_133":185},{"_151":181,"_33":182,"_154":183},{"_33":128,"_189":190},{"_197":198,"_199":-5,"_200":-5},[204,205,206],[328,330,332,334,336,337,338,340,341,342,343,344,345,346,347,348,349,350],{"_214":329},"MCP Server | Glama",{"_217":331,"_33":31},"Enterprise-grade security, privacy, and features like agents, MCP, prompt templates, and more.",{"_219":333,"_221":222,"_223":224},"https://glama.ai/mcp/servers/@bytebase/dbhub/blob/main/",{"_217":335,"_226":227},"MCP Server",{"_217":331,"_226":229},{"_217":231,"_226":232},{"_217":339,"_226":235},"https://glama.ai/generated-images/og?title=MCP+Server",{"_217":237,"_226":238},{"_217":240,"_226":241},{"_217":243,"_226":244},{"_217":333,"_226":246},{"_217":248,"_226":249},{"_217":251,"_33":252},{"_217":248,"_33":254},{"_217":331,"_33":256},{"_217":339,"_33":258},{"_217":237,"_33":260},{"_217":240,"_33":262},"path","","treeMembers",[355,358,360,361,363,365,367,369,371,373,375,377,379,380,382,384,386,388,390,392,394],{"_351":356,"_90":357},".github","tree",{"_351":359,"_90":357},".husky",{"_351":194,"_90":357},{"_351":362,"_90":357},"scripts",{"_351":364,"_90":357},"src",{"_351":366,"_90":295},"CLAUDE.md",{"_351":368,"_90":295},"Dockerfile",{"_351":370,"_90":295},".dockerignore",{"_351":372,"_90":295},".env.example",{"_351":374,"_90":295},".gitignore",{"_351":376,"_90":295},"LICENSE",{"_351":378,"_90":295},"llms-full.txt",{"_351":299,"_90":295},{"_351":381,"_90":295},"package.json",{"_351":383,"_90":295},"pnpm-lock.yaml",{"_351":385,"_90":295},"pnpm-workspace.yaml",{"_351":387,"_90":295},".prettierrc.json",{"_351":389,"_90":295},"README.md",{"_351":391,"_90":295},"tsconfig.json",{"_351":393,"_90":295},"tsup.config.ts",{"_351":395,"_90":295},"vitest.config.ts","actionData","errors"]

MCP directory API