Provides tools for interacting with MongoDB databases, including listing collections (currently the only NoSQL tool), with plans for more operations.
Provides RDBMS tools for MySQL databases: read/write queries, table management, export, schema inspection, and insights.
Provides RDBMS tools for PostgreSQL databases: read/write queries, table management, export, schema inspection, and insights.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@database-remote-mcp describe the customers table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
リモートデータベースへのアクセス機能を Model Context Protocol (MCP) ツールとして公開するサーバーです。HTTP と stdio の両トランスポートに対応しています。
MCP_TRANSPORT 環境変数でトランスポートを切替
未設定 / http → HTTP サーバーモード（/mcp, /mcp/stream）
stdio → stdin/stdout MCP プロトコルモード
DB_TYPE に応じてランタイムを自動切替
sqlserver / postgres / mysql -> RDBMS runtime
mongodb -> NoSQL runtime
ツールの有効化は環境変数で制御
RDBMS: ENABLED_TOOLS
NoSQL: ENABLED_NOSQL_TOOLS
Related MCP server: mongo-mcp
read_query
write_query
export_query
list_tables
describe_table
get_schema
create_table
alter_table
drop_table
append_insight
list_insights
list_collections（MongoDB のコレクション一覧取得）
NoSQL は現在 list_collections のみ実装済みです。
SQL Server（mssql）
PostgreSQL（pg）
MySQL（mysql2）
MongoDB（mongodb）
Node.js >= 24
pnpm 推奨
pnpm install
pnpm build
pnpm start # HTTPモード（デフォルト）stdioモード:
MCP_TRANSPORT=stdio pnpm start開発モード（HTTP）:
pnpm start:devClaude Code — グローバル登録（全プロジェクトで利用可能）:
claude mcp add database-remote-mcp --scope user -e MCP_TRANSPORT=stdio -- \
node --env-file=/path/to/database-remote-mcp/.env /path/to/database-remote-mcp/dist/main.jsClaude Code — プロジェクトローカル（.mcp.json）:
{
"mcpServers": {
"database-remote-mcp": {
"command": "node",
"args": [
"--env-file=/path/to/database-remote-mcp/.env",
"/path/to/database-remote-mcp/dist/main.js"
],
"env": {
"MCP_TRANSPORT": "stdio"
}
}
}
}Claude Desktop — claude_desktop_config.json:
{
"mcpServers": {
"database-remote-mcp": {
"command": "node",
"args": [
"--env-file=/path/to/database-remote-mcp/.env",
"/path/to/database-remote-mcp/dist/main.js"
],
"env": {
"MCP_TRANSPORT": "stdio"
}
}
}
}~/.codex/config.toml:
[mcp_servers.database-remote-mcp]
command = "node"
args = [
"--env-file=/path/to/database-remote-mcp/.env",
"/path/to/database-remote-mcp/dist/main.js"
]
[mcp_servers.database-remote-mcp.env]
MCP_TRANSPORT = "stdio".vscode/mcp.json:
{
"servers": {
"database-remote-mcp": {
"type": "stdio",
"command": "node",
"args": [
"--env-file=/path/to/database-remote-mcp/.env",
"/path/to/database-remote-mcp/dist/main.js"
],
"env": {
"MCP_TRANSPORT": "stdio"
}
}
}
}Claude Code — グローバル登録:
claude mcp add database-remote-mcp --scope user --transport http \
http://localhost:3000/mcp/streamClaude Desktop — claude_desktop_config.json:
{
"mcpServers": {
"database-remote-mcp": {
"type": "http",
"url": "http://localhost:3000/mcp/stream"
}
}
}~/.codex/config.toml:
[mcp_servers.database-remote-mcp]
url = "http://localhost:3000/mcp/stream"
enabled = true.vscode/mcp.json:
{
"servers": {
"database-remote-mcp": {
"type": "http",
"url": "http://localhost:3000/mcp/stream"
}
}
}.env.sample を .env にコピーして設定します。
APP_PORT=3000 # HTTPモードのみ使用
ALLOWED_ORIGINS=
DB_TYPE=postgres
MCP_TRANSPORT= # 未設定またはhttp=HTTPモード / stdio=stdioモードENABLED_TOOLS=
ENABLED_NOSQL_TOOLS=SERVER=localhost
PORT=5432
DATABASE=postgres
USER=postgres
PASSWORD=
DB_SSL=DB_TYPE が sqlserver / postgres / mysql のときに利用されます。
MONGO_URI=mongodb://localhost:27017
MONGO_DATABASE=adminMONGO_URI 未設定時は mongodb://SERVER:PORT を使用します。
依存方向: Presentation -> Application -> Domain <- Infrastructure
src/
├── app.module.ts # HTTPモード用ルートモジュール
├── app-stdio.module.ts # stdioモード用ルートモジュール（Presentation層なし）
├── presentation/ # HTTPモードのみ使用
│ └── mcp/
│ ├── mcp.controller.ts
│ ├── mcp.controller.module.ts
│ └── sse.interceptor.ts
├── application/
│ └── mcp/
│ ├── mcp.service.ts
│ ├── runtime-resolver.service.ts
│ ├── shared/ # connectStdio() を含む共通実装
│ ├── rdbms/
│ └── nosql/
├── domain/
│ ├── mcp/
│ │ ├── shared/
│ │ ├── rdbms/
│ │ └── nosql/
│ ├── rdbms/
│ └── nosql/
└── infrastructure/
├── config/
├── rdbms/
└── nosql/pnpm lint
pnpm build
pnpm testThis server cannot be deployed
Governed data discovery, exact queries, decisions, simulations, and runtime utilities over MCP.
Paid remote MCP for governed database query review, SQL simulation, approvals, and audits.
Hosted MCP server for AI-driven data ops. Create apps, manage schemas, and CRUD structured data.
Unified gateway exposing 150+ tools across all NexGenData MCP servers via one endpoint.
