dooor-os-mcp
OfficialProvides read-only SQL querying capabilities over an analytical data lake (ClickHouse).
Allows reading Harbor governance traces.
Click on "Install 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., "@dooor-os-mcpShow me total sales per region for this year."
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.
Dooor OS MCP server
Model Context Protocol (MCP) server for the Dooor OS platform. Exposes the workspace's apps, deploys, git, databases, agents, monitoring and connected business data as MCP tools so an MCP client (Claude Code, Claude Desktop, etc.) can operate the platform on your behalf.
Every tool is scoped to a single workspace, resolved from the API key you
provide. All data_* and lake_* tools are read-only.
The server discovers the active product contract before building its registry. It exposes only the product tools advertised for that workspace and fails closed when capability discovery is unavailable. This prevents one client's product-specific tools or schemas from appearing in another client's session.
Tool families
Start with capabilities when connecting a new client. It returns the active
workspace, API key scopes and tool families. Read-only probes are disabled by
default; opt in with includeProbes=true to receive compact counts, status and
freshness only.
capabilities: workspace whoami, scopes, family map and source probes.Platform tools: apps, deploys, git repos, env vars, databases, agents and monitoring.
data_products: discover which data products and capabilities are enabled for the active workspace.data_*: business questions over the connected operational sources exposed by the active product. Usedata_askfirst for most natural-language questions.data_connections,data_connection_capabilitiesanddata_connection_read: discover and read allowlisted entities from live operational connections through the Dooor read-only proxy.lake_*: analytical data through curated tools, paginated source discovery, raw browse, catalog discovery and read-only SQL, only when the active product advertises them.lake_sourcesdefaults to 10 clients and 50 tables per category/client; passsummary=truefor counts and Gold freshness only.lake_code_*: search or page through indexed business-rule source code, only when the active product advertises them.
Deploy readiness contract
The server instructions treat readiness review and deployment as separate operations. Requests to inspect, review, prepare, validate, or fix an app do not authorize a deployment. Before using a deployment tool, the connected agent is instructed to review the exact revision or artifact, verify the build and runtime contract, classify the result as READY, WARN, or BLOCKED, and report the commands and evidence used. A BLOCKED result must not be deployed, while a WARN result requires explicit acknowledgement of the remaining risks.
The instructions guide the connected agent, but they do not give the hosted MCP direct access to files on the user's machine. When the repository is available in the Claude Code workspace, Claude performs the source inspection and local checks with its own filesystem and shell tools. The Dooor deployment tools remain responsible for platform operations after explicit user authorization.
Managed platform domains
Use get_app_platform_domain to inspect an app's current short alias, set_app_platform_domain to reserve and route a globally unique label such as finance-copilot.apps.dooor.ai, and remove_app_platform_domain to release it. Managed aliases use the platform wildcard DNS, require no customer DNS records, preserve the generated tenant-scoped URL, and can briefly report TLS_ISSUING while cert-manager issues HTTPS. Setting and removing aliases require apps:write; reading requires apps:read.
Data freshness contract
For replicated sources, call data_sources during the current investigation
and treat lastSyncAt as the authoritative freshness timestamp when present.
Business dates, row createdAt or updatedAt, record insertion time, query or
connection-test activity, and request or application logs are not proof that a
sync ran.
If the provider exposes no field explicitly labeled as freshness, report freshness as unknown. State the observed timestamp and age, and only call a source stale or failed when authoritative freshness metadata and the expected cadence support that conclusion.
Related MCP server: kubeaid-mcp
Two ways to connect
Mode | Transport | Where the API key comes from |
Local (default) | stdio |
|
Remote (hosted) | Streamable HTTP |
|
You only need one. Most users run the local stdio server; the hosted server is for clients that prefer not to clone and build anything.
Local (stdio)
Clone and install:
git clone https://github.com/Dooor-AI/dooor-os-mcp.git
cd dooor-os-mcp
npm installnpm start compiles before starting, so the local MCP remains usable after a
fresh clone or cleanup without depending on an old dist/ directory.
Then register it with your MCP client, passing your workspace API key via the
DOOOR_API_KEY environment variable. Example MCP client config:
{
"mcpServers": {
"dooor-os": {
"command": "npm",
"args": ["--prefix", "/absolute/path/to/dooor-os-mcp", "start"],
"env": {
"DOOOR_API_KEY": "dor_sk_your_key_here"
}
}
}
}Optional env:
DOOOR_BASE_URL- override the API base URL (defaulthttps://api.os.dooor.ai/v1).
Remote (hosted) server
Instead of cloning and building, you can point your MCP client at the hosted
Dooor OS MCP endpoint and pass your workspace API key in the X-Api-Key
header. The hosted server speaks the MCP Streamable HTTP transport in
stateless mode: it reads the key from each request, so your data stays scoped
to your own workspace even though one instance serves many clients.
The key travels in
X-Api-Key(notAuthorization) because the hosted endpoint runs behind a front end that reserves theAuthorizationheader for its own auth.Authorization: Bearer dor_sk_...is also accepted by the server itself, for setups that forward that header untouched.
Claude Code:
claude mcp add --transport http dooor-os https://mcp.dooor.ai/mcp \
--header "X-Api-Key: dor_sk_your_key_here"Claude Desktop / .mcp.json (HTTP transport):
{
"mcpServers": {
"dooor-os": {
"type": "http",
"url": "https://mcp.dooor.ai/mcp",
"headers": {
"X-Api-Key": "dor_sk_your_key_here"
}
}
}
}Replace dor_sk_your_key_here with your workspace API key. Requests without a
valid key are rejected with 401. No cloning, building or updating: you always
get the latest tools.
Running the HTTP server yourself
npm install
npm run build
npm run start:httpThe server listens on 0.0.0.0:$PORT (default 8080):
POST /mcp- one JSON-RPC request per call; key read fromX-Api-Key(orAuthorization: Bearer).GET /health- returns200 {"status":"ok"}for health checks.
GET/DELETE /mcp return 405 because the server runs in stateless mode
(no long-lived session or server-initiated SSE stream). A Dockerfile is
included for container deploys (e.g. Cloud Run); it builds and runs
dist/http.js.
Error handling and rate limits
The hosted server does not return server-fault response bodies, stack traces,
internal exception messages, physical relation names, internal component
identifiers, adapter/runtime/provider identifiers, or infrastructure details.
Safe and neutral 4xx validation or governance reasons remain available so
callers can correct their requests. Public failures include a server-generated
correlation ID, also returned in the X-Correlation-Id response header. Share
that ID with the operator when troubleshooting. Caller-provided request IDs are
not trusted or echoed.
The HTTP process keeps a best-effort in-memory limit of 120 requests per minute for each hashed API key, plus a process-local concurrency guard. It is only a defense for that MCP instance. The Dooor backend is the authoritative source for global quotas and rate limits across every MCP instance. The MCP server does not identify or rate-limit clients by source IP because reverse proxies can make unrelated clients share one address.
Building an app with connected data
Use MCP while developing to discover what the workspace exposes. A running app
does not embed an MCP client and does not call connected systems directly. Its
backend calls the Dooor REST API with Authorization: Bearer <DOOOR_API_KEY>.
For replicated or curated data, use /data/* and /data/lake/*. For a live
operational connection, use this sequence:
GET /workspaces/{ws}/data-sourcesGET /workspaces/{ws}/data-sources/{sourceId}/capabilitiesPOST /workspaces/{ws}/data-sources/{sourceId}/operation
The operation body contains an advertised entity, operation (list or
get) and optional id, filter, cursor and maxRows. Dooor keeps source
credentials in its secret store, enforces configured fixed filters and returns
only allowlisted read data.
Create a dedicated key for each deployed app with only
data-sources:read and data-sources:query, restricted to the required
dataSourceIds. Store it only in the app backend's environment. Never reuse a
person's MCP key or expose the key to browser code. Call integration_guide for
a complete TypeScript client.
Development
npm run dev # tsc --watch
npm run typecheck
npm testThis server cannot be installed
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Servers
- Alicense-qualityDmaintenanceEnables MCP-compatible clients to interact with deployed Agent5ive agents as tools. Allows users to query agent purposes and send messages to leverage Agent5ive capabilities through natural language.73MIT
- AlicenseAqualityCmaintenanceExposes a Kubernetes cluster to MCP-compatible AI clients, enabling read-only and optional write operations on cluster resources like pods, deployments, and namespaces through natural language.91MIT
- Flicense-qualityCmaintenanceThis server exposes a Microsoft Fabric Data Agent as a native MCP tool, allowing clients to query the agent for KPIs, financial data, and other quantified project intelligence via natural language.
- Flicense-qualityCmaintenanceEnables natural language interaction with enterprise tools including file, database, GitHub, Slack, browser, calendar, email, vector search, and Python calculation through OpenAI and MCP Client.
Related MCP Connectors
Manage SRG+ hubs, channels, content, assets, users, and workspaces from any MCP-aware AI agent.
GibsonAI MCP server: manage your databases with natural language
Personal assistant MCP server with search, execute, packages, jobs, secrets, and integrations.
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/Dooor-AI/dooor-os-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server