Let your agent set up a warehouse, connect sources, and answer questions from your data.
Paste it into your agent, or read the setup guide.
Add the hosted endpoint to any OAuth-capable MCP client:
https://contrastdb.com/api/mcpContrast also serves the same warehouse tools at https://contrastdb.com/api/mcp/warehouse.
That's the address the MCP page in Contrast gives you. Either endpoint works with the
same sign-in and permissions; connect one, not both. See warehouse tools
for how their tool lists differ.
OAuth uses PKCE. Start authentication from your MCP client. Sign in or create an
account in the browser, verify your identity, then choose or create a workspace
and approve the client's access. Return to your agent and confirm a successful
warehouse status call. Signing in to the website alone does not authorize MCP.
codex mcp add contrast --url https://contrastdb.com/api/mcp
codex mcp login contrastSome clients, including Codex, report a failed MCP sign-in only in their own logs or status views. The agent just sees no Contrast tools. Check the connection status:
| Client | Command | Needs sign-in | Reconnect |
|---|---|---|---|
| Codex | codex mcp list | Status enabled, Auth Not logged in | codex mcp login <name> |
| Claude Code | claude mcp list | Needs authentication | claude mcp login <name>, or /mcp |
Use the name listed for https://contrastdb.com/api/mcp. Plugin installs use contrast
in Codex and plugin:contrast:contrast in Claude Code. If there is no entry, or it is
disabled, install or enable the plugin. Codex Unknown and Claude Code
Failed to connect mean the check couldn't reach Contrast, so retry with network
access. If the client shows a saved sign-in but the tools are still missing, check
https://api.embrasure.ai/health. If it returns 200, reconnect once. Otherwise
Contrast is unavailable, and signing in again won't help. Codex adds the tools to the
same chat after sign-in. In other clients, start a new chat or reconnect from /mcp.
If they still don't appear, contact support.
Both endpoints cover the same six areas: warehouse, sources, ingestion, catalog,
bi (charts, dashboards, and datasets), and query (read-only SQL).
| Endpoint | Tool list |
|---|---|
https://contrastdb.com/api/mcp | One tool per operation, such as warehouse_status, catalog_search, bi_create, and query_run. Also adds catalog context edits and ingestion column edits. |
https://contrastdb.com/api/mcp/warehouse | Six tools, one per area. Each takes an action, such as warehouse with action: "status". |
bi can delete a dataset, chart, or dashboard when you ask it to. No tool deletes sources,
tears down the warehouse, or runs write SQL. Inspect source capabilities before connecting. Source credentials
and consent use secure browser handoffs; never paste credentials into chat.
After authorization, let the agent provision the warehouse, connect the requested sources, start ingestion, and run a read-only query against ingested data. A sync job starting does not mean the data is ready. Finish with a verified answer and state any missing source coverage. Slack is optional and uses the existing browser setup described in the agent guide.
Use catalog with action lineage to list a table's upstream and downstream
tables.