whodb-cli
OfficialThis server provides comprehensive database management and exploration capabilities, allowing AI assistants to interact with multiple database connections across PostgreSQL, MySQL, SQLite, DuckDB, ClickHouse, and more.
List connections (
whodb_connections): View all configured database connections, including type, host, port, and source.Explore schemas & tables (
whodb_schemas,whodb_tables,whodb_columns): List schemas, tables (with row counts), and column details including data types, primary keys, and foreign keys.Visualize relationships (
whodb_erd): Retrieve ER diagram metadata showing tables, columns, and foreign key relationships.Execute SQL queries (
whodb_query): Run SELECT, INSERT, UPDATE, DELETE with parameterized query support to prevent SQL injection. Write operations require confirmation.Manage write confirmations (
whodb_confirm,whodb_pending): Approve pending write operations via time-limited tokens, or list all pending operations to recover lost tokens.Explain query plans (
whodb_explain): Run the database-native EXPLAIN to inspect execution plans before running queries.Audit data quality (
whodb_audit): Detect null-rate spikes, missing primary keys, duplicate rows, low-cardinality issues, and orphaned foreign keys.Compare schemas (
whodb_diff): Diff schema metadata between two connections to detect drift (e.g., staging vs. production).Get query suggestions (
whodb_suggestions): Receive starter queries to orient exploration of unfamiliar databases.AI integration: Supports natural language to SQL via Ollama, OpenAI, Anthropic, or compatible providers.
Allows querying and managing Elasticsearch indices and data within WhoDB.
Provides tools for connecting to and managing MariaDB databases, including browsing schemas and executing queries.
Enables interaction with MongoDB databases, including document browsing and CRUD operations.
Supports MySQL database management with features like query execution and schema exploration.
Integrates with Ollama for local AI-powered natural language to SQL query generation.
Integrates with OpenAI's API to enable natural language to SQL conversion for database queries.
Connects to PostgreSQL databases, allowing schema browsing, data editing, and query execution.
Allows connecting to Redis and performing operations like key-value management and data browsing.
Provides integration with Snowflake data warehouse for querying and data management.
Supports SQLite database management, including browsing, editing, and querying data.
WhoDB
A lightweight, self-hosted workspace for your databases
Available on
Quick start · Documentation · Live demo · Community
WhoDB gives you one place to explore your databases, edit data, run queries, and understand how a schema fits together. It runs in the browser, is easy to self-host, and is available as a desktop app or terminal CLI too.
Use it when you want to inspect a local database, help a teammate explore unfamiliar data, or work without installing a heavyweight database client. AI features are optional: connect Ollama, OpenAI, Anthropic, LM Studio, or another OpenAI-compatible provider if you want to ask questions in plain English.
Related MCP server: supabase-mcp
Quick start
Run WhoDB with Docker:
docker run --rm -it -p 8080:8080 clidey/whodbThen open http://localhost:8080 and enter your database connection details.
Want to look around first? Try the live demo or watch the video walkthrough.
What you can do
Browse and edit data in a spreadsheet-style grid with sorting, filtering, pagination, and inline editing.
Understand a schema visually with an interactive graph of tables and relationships.
Work through queries in a scratchpad with multiple cells, autocomplete, history, and results kept alongside each query.
Move data in and out with imports, exports, and mock-data generation for development and testing.
Ask questions in plain English using a local or hosted AI provider that you choose.
Work from your terminal through the WhoDB CLI and its MCP server.
Supported databases
WhoDB Community supports:
PostgreSQL, CockroachDB, YugabyteDB, and QuestDB
MySQL, MariaDB, and TiDB
SQLite and DuckDB
MongoDB and FerretDB
Redis, Valkey, and Dragonfly
Elasticsearch and OpenSearch
ClickHouse and Memcached
Support varies by database because not every system has the same concepts or capabilities. The connection screen shows the options available for each source.
Installation options
Docker with persistent sessions
The one-line Docker command is ideal for trying WhoDB. To keep encrypted login sessions when the container is replaced, first generate a key and save it somewhere secure:
openssl rand -hex 32Then mount /data and reuse that key whenever you start the container:
docker run -it -p 8080:8080 \
-v whodb-data:/data \
-e WHODB_ENCRYPTION_KEY=your_saved_64_character_hex_key \
clidey/whodbKeep that key somewhere safe. Changing it invalidates existing sessions. If WhoDB is served through an HTTPS reverse proxy, also set WHODB_SECURE=true so browsers only send the session cookie over HTTPS.
See the documentation for Docker Compose, connection profiles, SSL, AI providers, and other configuration options.
Desktop
CLI and MCP server
The CLI includes an interactive terminal UI and an MCP server for AI tools:
# macOS and Linux
curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash
# or install with npm
npm install -g @clidey/whodbwhodb # open the terminal UI
whodb mcp serve # start the MCP serverSee the CLI guide for connection examples and the full command reference.
AI providers
You can add a hosted AI provider directly from WhoDB—no backend configuration or restart is required. Open Chat, choose Add Provider from the provider menu, then select OpenAI, Anthropic, or Gemini and enter your API key. WhoDB will fetch the available models from that provider.
Ollama and LM Studio are available as local options in WhoDB Community. By default, the backend looks for Ollama at localhost:11434 and LM Studio at localhost:1234/v1, with local addresses adjusted automatically for Docker and WSL. Use WHODB_OLLAMA_HOST, WHODB_OLLAMA_PORT, or WHODB_LMSTUDIO_BASE_URL only when those defaults are not suitable for your setup.
Optional backend provider configuration
Environment variables let deployment administrators declare providers when the server starts. This is useful for preconfiguring OpenAI or Anthropic, changing provider endpoints, or adding an OpenAI-compatible service for everyone using that deployment:
WHODB_OPENAI_*for OpenAIWHODB_ANTHROPIC_*for AnthropicWHODB_OLLAMA_*for Ollama connection settingsWHODB_LMSTUDIO_*for LM Studio connection settingsWHODB_AI_GENERIC_<ID>_*for OpenAI-compatible providers
See the installation guide for the complete environment variable list and the AI provider guide for setup examples.
WhoDB Community and WhoDB Platform
This repository contains WhoDB Community, the Apache-2.0-licensed database workspace described above. It is free to self-host and is the best place to start if you want to explore and work with databases.
WhoDB Platform is the commercial, self-hosted edition for organizations that need shared projects, more data sources, SSO, fine-grained access controls, audit logs, pipelines, reporting, and internal apps. You can read the WhoDB overview or compare plans on the pricing page.
Development
WhoDB has a Go backend and a React/TypeScript frontend. For local development, run them in separate terminals.
Requirements:
Go
Node.js and pnpm
Start the backend:
cd core
go run ./cmd/whodbStart the frontend:
cd frontend
pnpm install
pnpm startThe frontend opens at http://localhost:3000 and talks to the backend on port 8080. See the installation guide for generation and build commands.
Contributing
Bug reports, feature ideas, documentation improvements, and code contributions are all welcome.
Open an issue for a bug or concrete request.
Start a discussion for questions and ideas.
Read CONTRIBUTING.md before sending a pull request.
More screenshots
Query scratchpad
Add and edit records
Build filters visually
Export data
Support
WhoDB is licensed under the Apache License 2.0.
If WhoDB saves you time, consider giving the project a star.
Available Tools
156 toolswhodb_mcp_setupADestructive
Start here for self-contained WhoDB MCP guidance and setup, without skills or shell access. inspect returns settings/schema/choices; preview validates a patch without saving; apply saves only a token-bound, user-approved preview; verify checks active targets. Restart after changes. Never send credentials.
Inputs: action (required), patch, approved, confirmation_token. Returns: object
whodb_platform_actionADestructive
Run a hosted platform resource action through the selected project.
Supported actions include transform run/cancel_run, file upload/rename/move/promote_to_dataset/restore/purge, folder rename/move/restore/purge, function deploy/redeploy/execute/start_run/generate_test_input, function_run cancel, ontology add_records/execute_behavior/share/unshare/reembed/purge_data, dataset purge_data, project restore/purge, app restore/purge/generate/cancel_generation/file operations, object restore/purge/version restore, package installation and add_changelog/add_media/review, and organization administration including service accounts (create_service_account, create_service_account_key, revoke_service_account_key, delete_service_account) and teams. Read whodb://platform/schema for every action and its payload shape. Some actions create, move, deploy, or otherwise mutate hosted resources. Pass id and payload_json as required by the action. For file/upload, payload_json requires file_path and may include folderId. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Permission checks are enforced by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: resource (required), id, action, payload, +3 more.
whodb_platform_active_versionARead-onlyIdempotent
Read the active production version for one versioned object. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), object_type (required), fields, workspace.
whodb_platform_add_ontology_recordADestructive
Add one row to a hosted ontology backing table.
Values are keyed by ontology property. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: values (required), entity_id (required), workspace, update_columns.
whodb_platform_add_ontology_recordsADestructive
Add many rows to a hosted ontology in one call.
rows are plain objects keyed by ontology property. Pass idempotency_key so a retried call never inserts duplicates. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: rows (required), entity_id (required), workspace, idempotency_key.
whodb_platform_ai_provider_modelsARead-onlyIdempotent
List model names available from one hosted AI provider. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: provider_id (required), fields, workspace.
whodb_platform_ai_providersARead-onlyIdempotent
List hosted AI provider metadata in the selected project. Use name and type filters when known.
This tool never returns provider API keys. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_appBRead-onlyIdempotent
Inspect one hosted app, including its generated definition. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, env, fields, version, +1 more.
whodb_platform_app_componentARead-onlyIdempotent
Look up exact usage for one app component category returned by whodb_platform_app_components. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, workspace.
whodb_platform_app_componentsARead-onlyIdempotent
List exact app component documentation categories from the hosted builder. Call before using unfamiliar component types. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, workspace.
whodb_platform_app_filesARead-onlyIdempotent
List the draft files of one hosted app: app.json, shared files, and every page, read one page per request so large apps fit. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, env, fields, version, +1 more.
whodb_platform_app_logic_graphBRead-onlyIdempotent
Map a hosted draft's page events, scripts, bindings, state, navigation, overlays, and function contract issues using the in-app builder audit. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), page, workspace.
whodb_platform_app_page_filesBRead-onlyIdempotent
Read the generated files for one page of a hosted app. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), page (required), env, fields, +1 more.
whodb_platform_appsBRead-onlyIdempotent
List hosted ontology-powered apps in the selected project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_app_screenshotARead-onlyIdempotent
Capture a rendered app page at desktop, mobile, or tablet size after optional actions or JavaScript. Returns a WebP image, visible text, diagnostics, and an optional interaction trace on compatible runtimes. Hosted writes are blocked. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: app (required), env, tab, page, +9 more. Returns: app, env, tab, page, +20 more
whodb_platform_app_sdkARead-onlyIdempotent
Look up exact app SDK usage for one category returned by whodb_platform_app_sdks. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, workspace.
whodb_platform_app_sdksARead-onlyIdempotent
List exact app SDK documentation categories from the hosted builder. Call before writing data or function integration code. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, workspace.
whodb_platform_app_version_viewBRead-onlyIdempotent
Read a promoted hosted app version. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, env, fields, version, +1 more.
whodb_platform_app_viewCRead-onlyIdempotent
Read the current hosted app view and generated files. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, env, fields, version, +1 more.
whodb_platform_app_viewsARead-onlyIdempotent
List pages in a hosted app by ID or exact name. Use a returned page with whodb_platform_app_screenshot. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: app (required), env, tab, page, +9 more. Returns: app, env, error, scope, +8 more
whodb_platform_build_planARead-onlyIdempotent
Return an end-to-end hosted platform build plan for a user goal.
Use this before coordinating a cross-resource workflow. It plans scope, ingest, persist, model, automate, runtime support, and governance phases using existing WhoDB platform terminology. It is read-only and never creates confirmation tokens. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal (required), fields, workspace, omit_files, +1 more.
whodb_platform_bundle_diffARead-onlyIdempotent
Compare a project bundle against the selected hosted project.
Pass bundle_json from whodb_platform_bundle_export or the CLI resources export command. This is read-only and returns create/skip actions. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: bundle_json (required), prefix, workspace, rename_conflicts, +1 more. Returns: plan, error, scope, counts, +9 more
whodb_platform_bundle_exportARead-onlyIdempotent
Export selected hosted project metadata as a portable bundle.
The bundle includes metadata for secrets, datasets, ontologies, transforms, functions, folders, and files. Secret values are never exported. File content is only exported when include_files is true and is capped by max_file_bytes. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace, include_files, max_file_bytes. Returns: error, scope, bundle, counts, +9 more
whodb_platform_bundle_importADestructive
Import a project bundle into the selected hosted project.
Use whodb_platform_bundle_import_plan first when possible. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the import preview. Supports prefix, rename_conflicts, and overwrite_conflicts. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: bundle_json (required), prefix, workspace, rename_conflicts, +1 more. Returns: error, scope, status, warning, +16 more
whodb_platform_bundle_import_planARead-onlyIdempotent
Plan how a project bundle would import into the selected hosted project.
This MCP tool is intentionally plan-only. Use the CLI resources import --yes command for execution after review. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: bundle_json (required), prefix, workspace, rename_conflicts, +1 more. Returns: plan, error, scope, counts, +9 more
whodb_platform_change_impactARead-onlyIdempotent
Analyze direct graph impact for a planned change.
Pass resource, id, and optional action before update, delete, deploy, run, move, or promotion work. It returns directly connected resources and recommended reads; it does not execute any change. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), resource (required), action, fields, +3 more.
whodb_platform_cloneADestructive
Clone a hosted dataset, ontology, transform, or function in the selected project.
Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source (required), new_name (required), resource (required), workspace. Returns: error, scope, status, warning, +16 more
whodb_platform_confirmADestructive
Confirm and execute a pending hosted WhoDB platform write.
Use the confirmation_token returned by hosted platform write tools. Tokens expire after 5 minutes. Only call this after the user has approved the pending write preview. The token does not independently prove human approval: the MCP host must enforce approval if that guarantee is required. For uploads, review the full local source path and destination; the file is read at execution time, not snapshotted when the preview is created. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: token (required), workspace. Returns: rows, error, scope, columns, +11 more
whodb_platform_createADestructive
Create a hosted platform resource through the selected project.
Supported resources: secret, ai_provider, ontology, ontology_fast_lookup, ontology_reference, dataset, transform, folder, function, app, package, lineage_provider, source_object. Pass payload_json as a JSON object matching the hosted platform mutation input. The selected projectId is injected automatically when applicable. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Permission checks are enforced by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: resource (required), id, action, payload, +3 more.
whodb_platform_create_datasetADestructive
Create a hosted dataset through the selected project.
Use this typed wrapper for normal dataset creation instead of raw whodb_platform_create when possible. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name (required), columns, source_id, workspace, +3 more.
whodb_platform_create_ontology_fast_lookupADestructive
Create a fast lookup for one hosted ontology.
Pass ontology property names in fields. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields (required), entity_id (required), reason, workspace.
whodb_platform_data_model_summaryARead-onlyIdempotent
Summarize selected-project data-model resources.
Use this before ontology, dataset, or lineage work. It returns sources, datasets, ontologies, graph relationships, modeling gaps, and the read tools an agent should call next. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace, omit_files, omit_lineage.
whodb_platform_datasetBRead-onlyIdempotent
Inspect one hosted dataset by id. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_dataset_rowsARead-onlyIdempotent
Preview rows for one hosted dataset.
Results are capped by the requested limit and the MCP --max-rows setting when provided. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), limit, fields, offset, +1 more.
whodb_platform_datasetsARead-onlyIdempotent
List datasets in the selected hosted project. Use name and schema_mode filters when known. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_deleteADestructive
Delete a hosted platform resource through the selected project.
Supported resources: secret, ai_provider, ontology, ontology_fast_lookup, ontology_reference, dataset, transform, file, folder, function, app, lineage_provider, source_object. This is destructive. Pass id for normal resources. For source_object, pass payload_json with sourceId, ref, and values. Default mode returns a confirmation token; explain exactly what will be deleted and do not call whodb_platform_confirm until the user approves the preview. Permission checks are enforced by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: resource (required), id, action, payload, +3 more.
whodb_platform_deleted_resourcesARead-onlyIdempotent
List restorable hosted resources visible to the signed-in user. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_delete_ontology_fast_lookupADestructive
Delete one hosted ontology fast lookup by id.
Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), workspace.
whodb_platform_delete_ontology_recordADestructive
Delete one hosted ontology row.
Pass values that identify the row, usually the primary key property. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: values (required), entity_id (required), workspace, update_columns.
whodb_platform_deletion_impactARead-onlyIdempotent
Inspect hosted dependents, references, and shared resources before deletion. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_doctorARead-onlyIdempotent
Check hosted WhoDB MCP readiness.
Use this when platform tools fail or before a workflow. It reports login, selected workspace, manifest availability, and actionable warnings. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: host, email, error, scope, +19 more
whodb_platform_file_inspectARead-onlyIdempotent
Inspect one hosted tabular file and infer promote-to-dataset column mappings.
Use this before whodb_platform_action with resource "file" and action "promote_to_dataset". Prefer fields such as ["columns", "columnMapExample", "columnMapFlags"] first. Set include_rows only when sample row values are needed. The suggested mappings are convenience output; the hosted platform still validates promotion writes. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: file_id (required), fields, workspace, sheet_index, +1 more.
whodb_platform_file_previewARead-onlyIdempotent
Preview one hosted project file.
Prefer fields such as ["mimeType", "sizeBytes", "isTabular"] before requesting body fields. Request "textContent" or "tabular" only when the file body or rows are needed. Text content is capped in MCP output. Tabular previews are returned as provided by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: file_id (required), fields, workspace, sheet_index.
whodb_platform_filesARead-onlyIdempotent
List folders and files in a hosted project folder.
Omit folder_id to list the project root. Use name, kind, and mime_type filters when known. Prefer fields such as ["files", "folders"] or ["storageUsed"] to request only the folder data needed now. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: kind, name, fields, folder_id, +2 more.
whodb_platform_file_searchBRead-onlyIdempotent
Search files in the selected hosted project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: query (required), fields, workspace.
whodb_platform_functionARead-onlyIdempotent
Inspect one ontology function by id.
Prefer fields to request only the details needed now, for example ["id", "name", "description"]. Request heavier fields such as "files" only when source code is needed. Function source file content is capped in MCP output. Secret bindings include secret ids only, never secret values. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_function_runsARead-onlyIdempotent
Return one persisted function run by run_id, or list recent runs for one function by function_id. Runs come from the function start_run action; each carries status, output, logs and error. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: limit, fields, run_id, workspace, +1 more.
whodb_platform_functionsARead-onlyIdempotent
List ontology functions in the selected hosted project.
Use name, type, and deployed filters when known; type maps to language for this tool. Prefer fields such as ["id", "name", "description", "isDeployed"] for discovery. Request heavier fields such as "files" only when source code is needed. Function source file content is capped in MCP output. Secret bindings include secret ids only, never secret values. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_function_waitARead-onlyIdempotent
Wait for a persisted hosted function run to complete, fail or be canceled, then return its output, logs and error. Use the run id returned by the function start_run action and keep the timeout bounded; a run keeps going after a timed-out wait. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: run_id (required), fields, workspace, poll_seconds, +1 more.
whodb_platform_gap_analysisARead-onlyIdempotent
Return a goal-aware gap analysis for the selected hosted project.
Use this when the agent needs to explain what is missing before building an app, data product, ontology workflow, transform pipeline, or AI-backed function. It returns ready areas, gaps, suggested tools, and next actions. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal, fields, workspace, omit_files, +1 more.
whodb_platform_hostsARead-onlyIdempotent
List saved platform hosts and account metadata without contacting servers. Saved credentials may have expired; status checks the selected login. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: hosts, scope, recovery, retryable, +4 more
whodb_platform_lineageARead-onlyIdempotent
Return lineage around one root node in the selected hosted project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: root_id (required), root_type (required), fields, direction, +2 more.
whodb_platform_lineage_neighborsARead-onlyIdempotent
Return immediate lineage neighbors for one node in the selected hosted project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: node_id (required), node_type (required), fields, workspace.
whodb_platform_lineage_providersBRead-onlyIdempotent
List OpenLineage providers configured for the selected project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_my_grantsBRead-onlyIdempotent
List the signed-in user's hosted resource grants. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_next_actionsARead-onlyIdempotent
Return deterministic suggested next actions for the selected hosted project.
Use this as a deeper action-ranking view after whodb_platform_workspace_summary or whodb_platform_gap_analysis. Suggestions are advisory only; backend permissions and write confirmations still apply. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal, fields, workspace, omit_files, +2 more.
whodb_platform_object_versionsBRead-onlyIdempotent
List promoted versions for an app, function, transform, dataset, or ontology. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), object_type (required), fields, workspace.
whodb_platform_ontologiesARead-onlyIdempotent
List ontology object types in the selected hosted project. Use name and status filters when known. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_ontologyARead-onlyIdempotent
Inspect one ontology object type by id. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_ontology_action_executionsARead-onlyIdempotent
List recorded behavior action executions for one record, newest first, including status and result summary. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: record_key (required), ontology_id (required), limit, fields, +1 more.
whodb_platform_ontology_action_previewARead-onlyIdempotent
Preview a behavior action without executing it: whether it is allowed, the proposed changes and the events it would emit. Show the preview to the user, then execute with whodb_platform_action execute_behavior. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: action (required), ontology_id (required), fields, values, +2 more.
whodb_platform_ontology_aggregateARead-onlyIdempotent
Compute exact SQL aggregates (COUNT, SUM, AVG, MIN, MAX) over one ontology, optionally grouped and filtered.
Pass group_by for one row per group and metrics for the values; omit group_by for a single total row. where uses the same grammar as whodb_platform_ontology_query (for example {"status":"open","amount":{"gte":100}}); a raw platform WhereCondition object is also accepted. Prefer this over whodb_platform_ontology_query when exact totals matter or the entity is large. Results are capped by limit and the MCP --max-rows setting. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), metrics (required), sort, limit, +5 more.
whodb_platform_ontology_describeARead-onlyIdempotent
Describe ontologies in plain text plus structured entities, fields and relationships. Call this first when answering a data question so property names and links are known. Empty entities describes the whole project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, entities, workspace, include_inferred.
whodb_platform_ontology_embedding_jobsARead-onlyIdempotent
List embedding backfill jobs for one ontology with progress and errors. Use after whodb_platform_action reembed and before whodb_platform_ontology_similar. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_ontology_fast_lookupsARead-onlyIdempotent
List saved fast lookups for one ontology object type. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_ontology_fast_lookup_suggestionsBRead-onlyIdempotent
List suggested fast lookups for one ontology object type. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_ontology_follow_linkARead-onlyIdempotent
Follow one ontology link from a row primary key and preview linked rows.
Results are capped by the requested limit and the MCP --max-rows setting when provided. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: entity_id (required), primary_key (required), link_api_name (required), limit, +3 more.
whodb_platform_ontology_queryARead-onlyIdempotent
Query ontology rows with filters, search, joins, grouping and metrics. Use this to answer data questions instead of paging through whodb_platform_ontology_rows.
where grammar: {"status":"open"}, {"amount":{"gte":100}}, {"_or":[{"region":"EU"},{"region":"UK"}]}. Operators: eq, neq, gt, gte, lt, lte, contains, icontains, isnull. group_by + metrics (count, count_distinct, sum, avg, min, max) return one row per group. The server scans at most scan_limit rows (default 1000, max 5000) before filtering, so totals on large entities may be partial; use whodb_platform_ontology_aggregate for exact SQL totals. Policy-protected ontologies reject this query; fall back to whodb_platform_ontology_rows. Results are capped by limit and the MCP --max-rows setting. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: entity (required), sort, joins, limit, +9 more.
whodb_platform_ontology_record_capabilitiesARead-onlyIdempotent
Report which properties the signed-in user can read and write on an ontology record and which behavior actions are allowed, with denial codes. Call before writing or executing actions. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: ontology_id (required), fields, workspace, record_key.
whodb_platform_ontology_reference_impactBRead-onlyIdempotent
Count links, apps, functions, transforms and behaviors that depend on one ontology reference before removing it. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_ontology_referencesBRead-onlyIdempotent
List shared ontologies referenced by the selected project and their status. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_ontology_rowsARead-onlyIdempotent
Preview rows for one ontology object type.
Results are capped by the requested limit and the MCP --max-rows setting when provided. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), limit, fields, offset, +1 more.
whodb_platform_ontology_similarARead-onlyIdempotent
Find rows similar to one row using the ontology's embeddings. Requires embeddingEnabled on the ontology and a completed embedding job; otherwise the platform returns an error explaining what is missing. Start a backfill with whodb_platform_action reembed. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: row_id (required), entity_id (required), top_k, where, +3 more.
whodb_platform_ontology_statsARead-onlyIdempotent
Return min, max, total and non-null counts for one ontology property, optionally filtered with the shared where grammar. Cheap way to profile a column before querying. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), property (required), where, fields, +1 more.
whodb_platform_org_domainsBRead-onlyIdempotent
List domains configured for the selected organization. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_org_membersBRead-onlyIdempotent
List members of the selected organization. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_org_package_installationsBRead-onlyIdempotent
List package installations across the selected organization, optionally for one package. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_org_resourcesBRead-onlyIdempotent
List resources visible in the selected organization. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_orgsARead-onlyIdempotent
List hosted WhoDB organizations visible to the authenticated user.
Use this after whodb login to discover valid organization ids, slugs, and names before selecting a workspace. This tool is read-only. Prefer fields such as ["id", "name", "slug", "selected"] for discovery. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace. Returns: host, orgs, count, error, +13 more
whodb_platform_org_ssoBRead-onlyIdempotent
List SSO providers configured for the selected organization without client secrets. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_packageBRead-onlyIdempotent
Inspect one hosted package and its requirements. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_package_installationsBRead-onlyIdempotent
List hosted package installations in the selected project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_package_installation_updateBRead-onlyIdempotent
Check whether a package installation has an update. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_package_libraryARead-onlyIdempotent
Search packages shared with the organization or available through the package library. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_packagesBRead-onlyIdempotent
List hosted package versions available in the selected project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id, fields, search, workspace.
whodb_platform_pendingARead-onlyIdempotent
List pending hosted WhoDB platform writes awaiting confirmation.
Use this to recover confirmation tokens returned by hosted platform write tools. Preview output contains metadata and changed field names only; it never includes credential or secret values. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: error, scope, pending, recovery, +5 more
whodb_platform_preview_create_packageARead-onlyIdempotent
Preview package contents and validation issues before creating a package. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: input_json (required), fields, workspace.
whodb_platform_preview_import_packageBRead-onlyIdempotent
Preview package import contents, requirements, and conflicts. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: input_json (required), fields, workspace.
whodb_platform_preview_install_packageBRead-onlyIdempotent
Preview package installation contents, requirements, and conflicts. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: input_json (required), fields, workspace.
whodb_platform_project_accessBRead-onlyIdempotent
Read the selected project's resource access matrix. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_project_active_versionsBRead-onlyIdempotent
List active production versions in the selected project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), object_type (required), fields, workspace.
whodb_platform_project_createADestructive
Create a hosted WhoDB project in an organization.
Pass org when the selected organization is not the intended target. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the project creation. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name (required), org, workspace, description. Returns: error, scope, status, warning, +16 more
whodb_platform_project_deleteADestructive
Delete a hosted WhoDB project.
This is destructive. Pass project as id, slug, or name and org when needed for disambiguation. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user explicitly approves the deletion. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: project (required), org, workspace. Returns: error, scope, status, warning, +16 more
whodb_platform_project_healthARead-onlyIdempotent
Return a compact health summary for the selected hosted project.
Use this for readiness diagnostics after whodb_platform_workspace_summary or whodb_platform_gap_analysis. It combines project counts, readiness checks, warnings, selected scope, and top suggested next actions. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal, fields, workspace, omit_files, +2 more.
whodb_platform_project_lineageBRead-onlyIdempotent
Return project-level lineage for the selected hosted project. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_project_renameADestructive
Rename a hosted WhoDB project.
Pass project as id, slug, or name and org when needed for disambiguation. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the rename. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name (required), project (required), org, slug, +1 more. Returns: error, scope, status, warning, +16 more
whodb_platform_project_resourcesARead-onlyIdempotent
Summarize resources in the selected project for governance and deletion planning. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_projectsARead-onlyIdempotent
List hosted WhoDB projects in one organization.
Pass org as an organization id, slug, or name. If omitted, the selected organization is used when available; when the account has exactly one organization, that organization is used. This tool is read-only. Prefer fields such as ["id", "name", "slug", "selected"] for discovery. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: org, fields, workspace. Returns: host, count, error, items, +15 more
whodb_platform_promote_file_to_datasetADestructive
Promote a hosted project file to a dataset.
Use whodb_platform_file_inspect first to infer column_map values. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name (required), file_id (required), column_map (required), workspace, +2 more.
whodb_platform_resolve_resourceARead-onlyIdempotent
Resolve a hosted resource name or id to an exact project resource before reading, planning, or writing it. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: query (required), resource (required), workspace. Returns: error, query, scope, commands, +12 more
whodb_platform_resource_accessARead-onlyIdempotent
List subjects with access to a hosted resource. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_resource_graphARead-onlyIdempotent
Return a normalized graph of hosted platform resources and relationships in the selected project.
Use this when an agent needs to understand how sources, datasets, files, ontologies, functions, secrets, AI providers, and lineage relate before proposing changes. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace, omit_files, omit_lineage.
whodb_platform_resource_permissionsBRead-onlyIdempotent
List the signed-in user's permissions for a hosted resource. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_resource_types_accessBRead-onlyIdempotent
List hosted resource ids the signed-in user can access for a resource type. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_restoreADestructive
Restore a soft-deleted hosted resource through the platform's existing restore path. This never purges data and still requires confirmation. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), resource (required), workspace.
whodb_platform_runtime_readinessARead-onlyIdempotent
Summarize selected-project runtime readiness.
Use this before function, transform, AI provider, or secret work. It returns configured resources and timestamped evidence. Reachability and verification stay unknown unless supported by evidence. Optional function_id inspects the latest persisted run without executing it; historical success is not current worker health. Unavailable inventories are partial results with warnings. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal, fields, workspace, omit_files, +2 more.
whodb_platform_secretsARead-onlyIdempotent
List hosted project secret metadata and usage. Use name to filter by secret name when known.
This tool never returns secret values, redacted placeholders, or credential material. Authorization is enforced by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_security_auditARead-onlyIdempotent
Search the canonical security ledger, correlate requests/runs, inspect export backlog or verify the organization hash chain. Requires organization management. Distinct from data-quality audit. Modes: events, exports, verify. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: mode, limit, since, until, +8 more.
whodb_platform_service_accountsARead-onlyIdempotent
List service accounts and key metadata in the selected organization. Keys never include secrets. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_session_clearARead-onlyIdempotent
Clear the session default set by whodb_platform_session_use.
Later calls that omit workspace fall back to process overrides, then saved CLI defaults. Nothing is written to the CLI config.
Returns: error, status, request_id, session_scope
whodb_platform_session_useARead-onlyIdempotent
Set the default host, organization, and project for this MCP session only.
Pass workspace {host, org, project}. The login is verified and the target is resolved to canonical IDs; later calls that omit workspace use it. Nothing is written to the CLI config, so other chats, terminals, and MCP sessions are unaffected. Use this once at the start of a chat that should stay on one host (for example UAT or production), then call whodb_platform_status to confirm. An explicit workspace on a later call still overrides it for that call. Call whodb_platform_session_clear to return to process/saved defaults. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: error, scope, status, recovery, +6 more
whodb_platform_setup_statusARead-onlyIdempotent
Check hosted WhoDB MCP setup before auth-dependent tools.
Use this as the first tool in hosted platform mode, or whenever another platform tool reports login/workspace errors. It does not require a valid hosted session. It reports whether the local CLI is logged in, whether an organization/project is selected, and exact commands the user can run to fix setup. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: host, email, error, scope, +19 more
whodb_platform_source_columnsBRead-onlyIdempotent
Describe columns for one hosted WhoDB source object.
Use a source name or id and an object ref such as table:public.users. This tool is read-only. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: ref (required), source (required), fields, workspace. Returns: count, error, items, scope, +12 more
whodb_platform_source_configARead-onlyIdempotent
Return redacted connection configuration for one hosted WhoDB source.
Secrets such as passwords, tokens, client secrets, and private keys are masked. Use this to understand source shape without exposing credentials. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source (required), workspace. Returns: error, scope, config, source, +9 more
whodb_platform_source_constraintsBRead-onlyIdempotent
Describe editable field constraints for one hosted source object.
Use a source name or id and an object ref such as table:public.users. This tool is read-only. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: ref (required), source (required), fields, workspace.
whodb_platform_source_contentARead-onlyIdempotent
Read content for one hosted source object when the source supports content reads.
Use a source name or id and an object ref such as item:notes/report.txt. Prefer fields to request only the content metadata or body fields needed now, then call again with more fields only if needed. Text content is capped in MCP output. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: ref (required), source (required), fields, workspace.
whodb_platform_source_createADestructive
Prepare creation of a hosted WhoDB source in the selected project.
This stores nothing until the returned confirmation token is approved with whodb_platform_confirm. Pass source_type, name, connection fields, and advanced options. Do not call whodb_platform_confirm until the user approves the confirmation preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name (required), source_type (required), port, advanced, +5 more. Returns: error, scope, source, status, +15 more
whodb_platform_source_deleteADestructive
Prepare deletion of a hosted WhoDB source.
This deletes nothing until the returned confirmation token is approved with whodb_platform_confirm. Use whodb_platform_sources first to verify the target source. This is destructive. Explain the deletion target and do not call whodb_platform_confirm until the user approves the confirmation preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source (required), workspace. Returns: error, scope, source, status, +15 more
whodb_platform_source_fieldsARead-onlyIdempotent
List connection fields for one hosted WhoDB source type.
Use this before source creation or draft connection tests to discover required fields and defaults. This tool is read-only and does not expose credentials. Prefer fields such as ["Key", "Kind", "Required", "LabelKey"] unless full field metadata is needed. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source_type (required), fields, workspace. Returns: count, error, items, scope, +13 more
whodb_platform_source_objectsARead-onlyIdempotent
Browse objects in one hosted WhoDB source.
Use the source name or id from whodb_platform_sources. Parent refs use kind:path, for example schema:public. This tool is read-only. Prefer fields such as ["Name", "Kind", "HasChildren"] while browsing. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source (required), kinds, fields, parent, +3 more. Returns: count, error, items, scope, +12 more
whodb_platform_source_rowsARead-onlyIdempotent
Preview rows for one hosted WhoDB source object.
Use a source name or id and an object ref such as table:public.users. Results are capped by the requested limit and the MCP --max-rows setting when provided. This tool is read-only. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: ref (required), source (required), limit, offset, +1 more. Returns: rows, error, scope, total, +11 more
whodb_platform_sourcesARead-onlyIdempotent
List hosted WhoDB sources in the selected organization and project.
Requires a saved login on the target host. Pass workspace {host, org, project}, or omit it to use process/saved defaults. This tool is read-only and never exposes source credentials. Prefer fields such as ["id", "name", "type"] for discovery; request more fields only when needed. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace. Returns: host, count, error, items, +15 more
whodb_platform_source_testARead-onlyIdempotent
Test a hosted WhoDB source connection.
Pass source to test an existing saved source. Omit source and pass source_type plus connection fields to test a draft config without saving it. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: port, source, advanced, database, +5 more. Returns: error, scope, source, status, +10 more
whodb_platform_source_typesARead-onlyIdempotent
List hosted WhoDB source types available for source creation.
Use this before whodb_platform_source_create or draft whodb_platform_source_test to discover valid source_type values. This tool is read-only. Prefer fields such as ["id", "label"] before requesting full source type metadata. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace. Returns: count, error, items, scope, +12 more
whodb_platform_source_updateADestructive
Prepare update of a hosted WhoDB source.
This changes nothing until the returned confirmation token is approved with whodb_platform_confirm. Omitted config fields preserve the existing hosted values. Do not call whodb_platform_confirm until the user approves the confirmation preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: source (required), name, port, advanced, +5 more. Returns: error, scope, source, status, +15 more
whodb_platform_statusARead-onlyIdempotent
Report the current hosted WhoDB login and selected hosted workspace.
Requires a prior hosted login with whodb login. Use this before other whodb_platform_* tools to confirm which host, organization, and project are active. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: host, email, error, scope, +21 more
whodb_platform_storage_usageARead-onlyIdempotent
Return selected hosted project storage usage in bytes. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_tabular_filesARead-onlyIdempotent
List hosted project files that can be used as tabular data. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_team_membersBRead-onlyIdempotent
List members of one organization team. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_teamsARead-onlyIdempotent
List organization teams. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, team_id, workspace, resource_id, +1 more.
whodb_platform_transformBRead-onlyIdempotent
Inspect one transform in the selected hosted project. Use fields to request only the top-level fields needed for the current task. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: id (required), fields, workspace.
whodb_platform_transform_previewARead-onlyIdempotent
Run a transform graph without saving it and return the resulting rows. Use to validate a graph before whodb_platform_create transform or whodb_platform_action run. Results are capped by the MCP --max-rows setting. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: graph_json (required), fields, workspace.
whodb_platform_transform_runsARead-onlyIdempotent
List recent runs for one hosted transform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: transform_id (required), limit, fields, workspace.
whodb_platform_transformsARead-onlyIdempotent
List transforms in the selected hosted project. Use name and type filters when known; type maps to trigger mode for this tool. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: name, type, limit, fields, +6 more.
whodb_platform_transform_waitARead-onlyIdempotent
Wait for a real hosted transform run to reach success or failure. Use the run id returned by whodb_platform_action and keep the timeout bounded. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: run_id (required), transform_id (required), fields, workspace, +2 more.
whodb_platform_updateADestructive
Update a hosted platform resource through the selected project.
Supported resources: secret, ai_provider, ontology, dataset, transform, function, app, lineage_provider, source_object. Pass id when required and payload_json with changed fields only. Secret-like payload fields are never shown in confirmation previews. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Permission checks are enforced by the hosted platform. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: resource (required), id, action, payload, +3 more.
whodb_platform_update_ontology_recordADestructive
Update one hosted ontology row.
Pass values containing both matcher values and replacement values, plus update_columns naming the properties to update. Default mode returns a confirmation token; do not call whodb_platform_confirm until the user approves the preview. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: values (required), entity_id (required), workspace, update_columns.
whodb_platform_user_owned_resourcesARead-onlyIdempotent
List resources owned by one organization member, for example before removing them. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: user_id (required), fields, workspace.
whodb_platform_user_resource_accessARead-onlyIdempotent
List resources one organization member can access and how that access was granted. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: user_id (required), fields, workspace.
whodb_platform_workflow_applyBDestructive
Request confirmation to apply or resume a hosted WhoDB workflow plan. Completed steps are skipped on retry. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: plan_id (required), workspace. Returns: plan, error, plans, scope, +14 more
whodb_platform_workflow_getARead-onlyIdempotent
Read one hosted WhoDB workflow plan and its step status without returning payload values. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: plan_id (required), workspace. Returns: plan, error, plans, scope, +14 more
whodb_platform_workflow_listARead-onlyIdempotent
List persisted hosted WhoDB workflow plans for the selected workspace. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: plan, error, plans, scope, +14 more
whodb_platform_workflow_planBRead-onlyIdempotent
Validate and persist a multi-step hosted WhoDB workflow without executing writes. Use this for end-to-end goals such as source to dataset to transform to app. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal (required), steps (required), workspace. Returns: plan, error, plans, scope, +14 more
whodb_platform_workflow_recipeARead-onlyIdempotent
Return a goal-oriented, read-first recipe for using the hosted WhoDB platform. This never executes writes; use its steps to build and apply a confirmed workflow. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal (required), fields, workspace.
whodb_platform_workspace_mapARead-onlyIdempotent
Return a compact selected-project map across hosted sources, secrets, AI providers, datasets, ontologies, transforms, functions, root files, storage, and lineage.
Use this when the agent needs a full resource inventory after first checking whodb_platform_workspace_summary. It is read-only and never returns secret values. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: fields, workspace, omit_files, omit_lineage.
whodb_platform_workspace_resolveARead-onlyIdempotent
Resolve workspace {host, org, project} to canonical IDs and verify the login. Does not switch or save defaults. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: workspace. Returns: host, email, error, scope, +21 more
whodb_platform_workspace_summaryARead-onlyIdempotent
Return a compact, goal-aware summary of the selected hosted project.
Use this when the user asks what the platform project contains or what can be built. It combines scope, counts, highlights, gaps, next actions, recommended tools, warnings, and lineage summary without drilling into every item. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: goal, fields, workspace, omit_files, +1 more.
whodb_platform_write_planARead-onlyIdempotent
Validate and preview a hosted platform write without executing it.
Use this before calling mutating tools when the agent needs a safe dry-run summary. It reuses the same generic write specs as real writes, returns payload keys, suggested reads, and direct impact, but does not create a confirmation token. Accepts workspace {host, org, project} for per-call targeting without changing defaults.
Inputs: resource (required), operation (required), id, action, +6 more.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 156 tools
The surface is riddled with overlapping read tools that all answer 'what's in my project' (workspace_summary, workspace_map, project_health, project_resources, data_model_summary, resource_graph, next_actions, gap_analysis), and four competing write paths (generic create/update/action, typed source_create/create_dataset wrappers, preview, write_plan, workflow_apply). The near-identical preview_* family (preview_create_package, preview_import_package, preview_install_package, preview_shared_import, preview_shared_install) and the product-specific ontology query/rows/aggregate/stats/follow_link set are better delimited, but an agent must read long prose to choose correctly.
Everything uses snake_case with the whodb_platform_ prefix, which helps, but there is no consistent verb_noun scheme: list tools are bare nouns (sources, datasets, ontologies, packages, teams), reads use inspect/read/view/get variably, and there are singular/plural pairs (app_sdk/app_sdks, app_view/app_views, project_access/resource_access, installation vs installations). The lone whodb_mcp_setup breaks the prefix convention entirely.
156 tools is far beyond any reasonable scope and will swamp an agent's context and selection accuracy, even for a broad hosted data platform. Many entries are thin variations of each other, so the count reflects surface sprawl rather than earned capability.
Coverage is genuinely deep: CRUD for sources, datasets, ontologies, transforms, functions, apps and packages, plus sharing, lineage, versions, storage, org/team admin, confirmation lifecycle and workflow persistence. Some operations are only reachable through the catch-all whodb_platform_action and external schema document, which is a minor gap but not a dead end.
Maintenance
Related MCP Connectors
Self-hosted AI workspace: semantic RAG document search, long-term memory, and AI chat via MCP.
Butterbase MCP server — manage your backend: schemas, auth, functions, storage, RAG, deploys.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- FlicenseBqualityDmaintenanceFireproof ledger database with multi-user sync431-
- AlicenseNot gradedqualityNot gradedmaintenanceAn MCP server that provides tools for interacting with Supabase databases, storage, and edge functions.45MIT
- AlicenseNot gradedqualityAmaintenanceThe Multi DB MCP Server is a high-performance implementation of the Database Model Context Protocol designed to revolutionize how AI agents interact with databases. Currently supporting MySQL and PostgreSQL databases.485MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants like Claude to interact with MongoDB databases through standardized MCP tools. Supports full CRUD operations, aggregations, and natural language queries with Clean Architecture and dual transport modes (STDIO/HTTP).MIT