Skip to main content
Glama
whodb-cli

whodb-cli

Official
by clidey

WhoDB

Lightweight, Fast, and Beautiful Database Management

Release workflow release version release date docker pulls release downloads docker size

Commits per month last commit PRs Welcome contributors closed issues closed PRs

License GitHub Stars Go TypeScript Go Report Card

Available on

Docker Windows macOS Snap CLI

🚀 Quick Start • 📖 Documentation • 🎮 Live Demo • 💬 Community


Related MCP server: supabase-mcp

🎯 What is WhoDB?

WhoDB is the modern database management tool that developers actually want to use.

Built with GoLang and React, WhoDB is a lightweight (<50MB) yet powerful database client that combines blazing-fast performance with an intuitive, beautiful interface. Whether you're debugging a production issue, exploring a new database schema, or managing data for your next feature, WhoDB makes database management feel effortless.

Why WhoDB?

🚀 Lightning Fast

  • Instant startup (<1s)

  • Real-time query results

  • Efficient table virtualization

  • 90% less resource usage than traditional tools

🎨 Beautiful & Intuitive

  • Clean, modern interface

  • Spreadsheet-like data grid

  • Interactive schema visualization

  • No training required

🤖 AI-Powered

  • Natural language to SQL

  • Talk to your data conversationally

  • Supports Ollama, OpenAI, Anthropic, and any OpenAI-compatible provider

  • No complex query writing needed

🔧 Developer-Friendly

  • Multi-database support

  • Query history & management

  • Mock data generation

  • Flexible export options

✨ Key Features

📊 Visual Data Management

Spreadsheet-Like Data Grid

  • View, edit, and manage data intuitively

  • Sort, filter, and search with ease

  • Inline editing with real-time updates

  • Bulk operations for efficiency

🔍 Interactive Schema Explorer

Visual Schema Topology

  • Interactive graph visualization

  • Explore table relationships

  • Understand foreign keys instantly

  • Pan, zoom, and navigate easily

💻 Powerful Query Interface

Scratchpad Query Editor

  • Jupyter-like notebook interface

  • Syntax highlighting & auto-completion

  • Query history & reuse

  • Multi-cell organization

🗄️ Multi-Database Support

Community Edition (CE): PostgreSQL, MySQL, SQLite3, MongoDB, Redis, MariaDB, ElasticSearch

Enterprise Edition (EE): All CE databases plus Oracle, SQL Server, DynamoDB, Athena, Snowflake, Cassandra, and more

🎯 Advanced Capabilities

  • Mock Data Generation - Generate realistic test data for development

  • Flexible Export Options - Export to CSV, Excel, JSON, or SQL

  • Advanced Filtering - Build complex WHERE conditions visually

  • AI-Powered Queries - Convert natural language to SQL with Ollama, OpenAI, Anthropic, or any OpenAI-compatible provider


🎮 Try WhoDB Now

Experience WhoDB in action without any setup


🚀 Quick Start

The fastest way to get started with WhoDB:

docker run -it -p 8080:8080 clidey/whodb

Then open http://localhost:8080 in your browser.

Option 2: Docker Compose

For more control and configuration:

version: "3.8"
services:
  whodb:
    image: clidey/whodb
    ports:
      - "8080:8080"
    environment:
      # AI Integration (Optional)
      # Ollama Configuration
      - WHODB_OLLAMA_HOST=localhost
      - WHODB_OLLAMA_PORT=11434

      # Anthropic Configuration
      - WHODB_ANTHROPIC_API_KEY=your_key_here
      # - WHODB_ANTHROPIC_ENDPOINT=https://api.anthropic.com/v1

      # OpenAI Configuration
      - WHODB_OPENAI_API_KEY=your_key_here
      # - WHODB_OPENAI_ENDPOINT=https://api.openai.com/v1

      # Generic AI Providers (OpenAI-compatible endpoints)
      # Use WHODB_AI_GENERIC_<ID>_* to add any OpenAI-compatible provider.
      # <ID> can be any unique identifier (e.g., LMSTUDIO, OPENROUTER).
      #
      # LM Studio example:
      # - WHODB_AI_GENERIC_LMSTUDIO_NAME=LM Studio
      # - WHODB_AI_GENERIC_LMSTUDIO_BASE_URL=http://host.docker.internal:1234/v1
      # - WHODB_AI_GENERIC_LMSTUDIO_MODELS=mistral-7b,llama-3-8b
      #
      # OpenRouter example:
      # - WHODB_AI_GENERIC_OPENROUTER_NAME=OpenRouter
      # - WHODB_AI_GENERIC_OPENROUTER_BASE_URL=https://openrouter.ai/api/v1
      # - WHODB_AI_GENERIC_OPENROUTER_API_KEY=your_key_here
      # - WHODB_AI_GENERIC_OPENROUTER_MODELS=google/gemini-2.0-flash-001,anthropic/claude-3.5-sonnet
    # volumes: # (Optional for SQLite)
    #   - ./sample.db:/db/sample.db

What's Next?

  1. Connect to your database - Enter your database credentials on the login page

  2. Explore your schema - Browse tables and visualize relationships

  3. Run queries - Use the Scratchpad to execute SQL queries

  4. Manage data - Edit, add, and delete records with ease

📖 For detailed installation options and configuration, see our Documentation


💻 WhoDB CLI

WhoDB also offers a powerful command-line interface with an interactive TUI (Terminal User Interface) and MCP server support for AI assistants.

Features

  • Interactive TUI - Full-featured terminal interface for database management

  • MCP Server - Model Context Protocol support for Claude, Cursor, and other AI tools

  • Cross-Platform - Available for macOS, Linux, and Windows

Quick Install

# macOS/Linux
curl -fsSL https://raw.githubusercontent.com/clidey/whodb/main/cli/install/install.sh | bash

# Homebrew (coming soon)
brew install whodb-cli

# npm
npm install -g @clidey/whodb-cli

Usage

# Launch interactive TUI
whodb-cli

# Run as MCP server for AI assistants
whodb-cli mcp serve

📖 For full CLI documentation, see the CLI README


🛠️ Development Setup

Prerequisites

  • GoLang - Latest version recommended

  • PNPM - For frontend package management

  • Node.js - Version 16 or higher

Editions

Community Edition (CE)

  • PostgreSQL

  • MySQL / MariaDB

  • SQLite3

  • MongoDB

  • Redis

  • ElasticSearch

Enterprise Edition (EE)

  • All CE databases

  • Oracle

  • SQL Server

  • DynamoDB

  • Athena

  • Snowflake

  • Cassandra

  • And more...

📚 See BUILD_AND_RUN.md for detailed build instructions and ARCHITECTURE.md for architecture details.

Frontend Development

Navigate to the frontend/ directory and start the development server:

cd frontend
pnpm i
pnpm start

Backend Development

1. Build Frontend (First-Time Setup)

If the core/build/ directory doesn't exist, build the frontend first:

cd frontend
pnpm install
pnpm run build
rm -rf ../core/build/
cp -r ./build ../core/
cd ..

Note: This is only required once, as Go embeds the build/ folder on startup.

2. Setup AI Integration (Optional)

To enable natural language queries:

  1. Ollama - Download from ollama.com

    # Install Llama 3.1 8b model
    ollama pull llama3.1

    WhoDB will auto-detect installed models and show a Chat option in the sidebar.

  2. OpenAI/Anthropic - Set environment variables (see Docker Compose example above)

  3. Any OpenAI-compatible provider - Use WHODB_AI_GENERIC_<ID>_* environment variables to connect to LM Studio, OpenRouter, or any provider with an OpenAI-compatible API (see Docker Compose example above)

3. Start Backend Service

cd core
go run ./cmd/whodb

The backend will start on http://localhost:8080


💼 Use Cases

👨‍💻 For Developers

Local Development

  • Quick database inspection during development

  • Debug production issues with read-only access

  • Test API endpoints with real data

  • Explore schema changes

API Development

  • Validate data transformations

  • Test query performance

  • Generate mock data for testing

  • Export data for integration tests

📊 For Data Analysts

  • Run ad-hoc SQL queries quickly

  • Export data to Excel for analysis

  • Build complex filters visually

  • Visualize table relationships

🧪 For QA Engineers

  • Generate realistic test data

  • Verify database state during testing

  • Debug test failures quickly

  • Validate data migrations

🛠️ For Database Administrators

  • Monitor table structures and indexes

  • Manage user data efficiently

  • Quick schema exploration

  • Emergency data fixes


❓ Frequently Asked Questions

WhoDB combines the lightweight nature of tools like Adminer with modern UX, powerful visualizations, and AI capabilities. Unlike resource-heavy tools like DBeaver, WhoDB uses 90% less memory while providing a faster, more intuitive experience.

Yes, WhoDB is production-ready and used by thousands of developers. For production environments, we recommend:

  • Using read-only database accounts when possible

  • Enabling SSL/TLS connections

  • Consider Enterprise Edition for audit logging and advanced security features

WhoDB implements several performance optimizations:

  • Table virtualization for efficient rendering

  • Lazy loading for large result sets

  • Pagination controls

  • Query result streaming

Community Edition: PostgreSQL, MySQL, MariaDB, SQLite3, MongoDB, Redis, ElasticSearch

Enterprise Edition: All CE databases plus Oracle, SQL Server, DynamoDB, Athena, Snowflake, Cassandra, and more

WhoDB can be deployed in multiple ways:

  • Docker - Single command deployment

  • Docker Compose - For production setups

  • Kubernetes - For enterprise environments

  • Binary - Direct installation on servers

See our Quick Start section for details.

No. WhoDB does not store database credentials by default. Connections are temporary and credentials are cleared when you close the browser. You can optionally configure connection profiles stored locally in your browser.

Yes! WhoDB integrates with:

  • Ollama - For local, private AI models

  • OpenAI - GPT-4 and other OpenAI models

  • Anthropic - Claude models

  • Any OpenAI-compatible provider - LM Studio, OpenRouter, vLLM, and more via WHODB_AI_GENERIC_<ID>_* environment variables

These integrations allow you to query your database using natural language instead of SQL.

🤝 Contributing

We welcome contributions from the community! Whether it's bug reports, feature requests, or code contributions, we appreciate your help in making WhoDB better.

How to Contribute

  1. Report Issues - Found a bug? Open an issue

  2. Request Features - Have an idea? Start a discussion

  3. Submit PRs - Want to contribute code? Check our Contributing Guide

  4. Improve Docs - Help us improve documentation

Development Resources


📸 Screenshots

Data Management

Add/Edit Records

Advanced Filtering

Export Options

Schema Graph Visualization

Scratchpad Query Editor

Query Results

Multiple Database Support


🏢 Infrastructure & Support

WhoDB's deployment and CI/CD are powered by Clidey, a no-code DevOps platform.

Contact & Support


⭐ Star Us on GitHub!

If you find WhoDB useful, please consider giving us a star on GitHub. It helps us grow the community and continue improving WhoDB.

GitHub stars


Built with ❤️ by the Clidey team

"Is it magic? Is it sorcery? No, it's just WhoDB!"

Available Tools

156 tools
whodb_mcp_setupA
Destructive

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_actionA
Destructive

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_versionA
Read-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_recordA
Destructive

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_recordsA
Destructive

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_modelsA
Read-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_providersA
Read-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_appB
Read-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_componentA
Read-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_componentsA
Read-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_filesA
Read-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_graphB
Read-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_filesB
Read-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_appsB
Read-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_screenshotA
Read-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_sdkA
Read-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_sdksA
Read-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_viewB
Read-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_viewC
Read-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_viewsA
Read-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_planA
Read-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_diffA
Read-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_exportA
Read-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_importA
Destructive

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_planA
Read-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_impactA
Read-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_cloneA
Destructive

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_confirmA
Destructive

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_createA
Destructive

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_datasetA
Destructive

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_lookupA
Destructive

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_summaryA
Read-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_datasetB
Read-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_rowsA
Read-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_datasetsA
Read-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_deleteA
Destructive

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_resourcesA
Read-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_lookupA
Destructive

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_recordA
Destructive

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_impactA
Read-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_discover_shared_ontologiesB
Read-onlyIdempotent

List ontologies other projects share that the selected project may reference. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: name, type, limit, fields, +6 more.

whodb_platform_doctorA
Read-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_inspectA
Read-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_previewA
Read-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_filesA
Read-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_functionA
Read-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_runsA
Read-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_functionsA
Read-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_waitA
Read-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_analysisA
Read-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_hostsA
Read-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_lineageA
Read-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_neighborsA
Read-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_providersB
Read-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_grantsB
Read-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_actionsA
Read-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_versionsB
Read-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_ontologiesA
Read-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_ontologyA
Read-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_executionsA
Read-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_previewA
Read-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_aggregateA
Read-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_describeA
Read-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_jobsA
Read-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_lookupsA
Read-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_suggestionsB
Read-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_queryA
Read-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_capabilitiesA
Read-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_impactB
Read-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_referencesB
Read-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_rowsA
Read-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_similarA
Read-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_statsA
Read-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_domainsB
Read-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_membersB
Read-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_installationsB
Read-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_resourcesB
Read-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_orgsA
Read-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_ssoB
Read-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_packageB
Read-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_installationsB
Read-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_updateB
Read-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_libraryA
Read-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_packagesB
Read-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_pendingA
Read-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_packageA
Read-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_packageB
Read-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_packageB
Read-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_preview_shared_importB
Read-onlyIdempotent

Preview import of a shared package. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: input_json (required), fields, workspace.

whodb_platform_preview_shared_installB
Read-onlyIdempotent

Preview installation of a shared package. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: input_json (required), fields, workspace.

whodb_platform_project_accessB
Read-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_versionsB
Read-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_createA
Destructive

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_deleteA
Destructive

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_healthA
Read-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_lineageB
Read-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_renameA
Destructive

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_resourcesA
Read-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_projectsA
Read-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_datasetA
Destructive

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_resourceA
Read-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_accessA
Read-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_graphA
Read-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_permissionsB
Read-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_accessB
Read-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_restoreA
Destructive

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_readinessA
Read-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_secretsA
Read-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_auditA
Read-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_accountsA
Read-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_clearA
Read-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_useA
Read-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_statusA
Read-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_shared_by_meB
Read-onlyIdempotent

List resources shared by 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_share_dependentsA
Read-onlyIdempotent

List resources that must be shared alongside a resource for it to work, with the default role for each. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: fields, team_id, workspace, resource_id, +1 more.

whodb_platform_shared_ontologiesB
Read-onlyIdempotent

List ontologies the selected project shares with other projects, including their consumers. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: name, type, limit, fields, +6 more.

whodb_platform_shared_packageB
Read-onlyIdempotent

Inspect a package shared through a hosted package share token. Accepts workspace {host, org, project} for per-call targeting without changing defaults.

Inputs: id, fields, search, workspace.

whodb_platform_shared_with_meA
Read-onlyIdempotent

List resources shared with 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_source_columnsB
Read-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_configA
Read-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_constraintsB
Read-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_contentA
Read-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_createA
Destructive

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_deleteA
Destructive

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_fieldsA
Read-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_objectsA
Read-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_rowsA
Read-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_sourcesA
Read-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_testA
Read-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_typesA
Read-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_updateA
Destructive

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_statusA
Read-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_usageA
Read-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_filesA
Read-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_membersB
Read-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_teamsA
Read-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_transformB
Read-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_previewA
Read-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_runsA
Read-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_transformsA
Read-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_waitA
Read-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_updateA
Destructive

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_recordA
Destructive

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_resourcesA
Read-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_accessA
Read-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_applyB
Destructive

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_getA
Read-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_listA
Read-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_planB
Read-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_recipeA
Read-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_mapA
Read-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_resolveA
Read-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_summaryA
Read-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_planA
Read-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

    B3.1/5.0

    Scored across 156 tools

    Disambiguation2/5

    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.

    Naming Consistency3/5

    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.

    Tool Count1/5

    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.

    Completeness4/5

    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

    ActivityActive
    ResponsivenessMixed handling

    Related MCP Connectors

    Related MCP Servers