whodb-cli
OfficialWhoDB
Lightweight, Fast, and Beautiful Database Management
Available on
🚀 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
Option 1: Docker (Recommended)
The fastest way to get started with WhoDB:
docker run -it -p 8080:8080 clidey/whodbThen 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.dbWhat's Next?
Connect to your database - Enter your database credentials on the login page
Explore your schema - Browse tables and visualize relationships
Run queries - Use the Scratchpad to execute SQL queries
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-cliUsage
# 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 startBackend 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:
Ollama - Download from ollama.com
# Install Llama 3.1 8b model ollama pull llama3.1WhoDB will auto-detect installed models and show a Chat option in the sidebar.
OpenAI/Anthropic - Set environment variables (see Docker Compose example above)
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/whodbThe 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
Report Issues - Found a bug? Open an issue
Request Features - Have an idea? Start a discussion
Submit PRs - Want to contribute code? Check our Contributing Guide
Improve Docs - Help us improve documentation
Development Resources
Contributing Guide - Detailed contribution guidelines
Architecture - Understanding the codebase
Build & Run - Development setup instructions
📸 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
Email: support@clidey.com
GitHub Issues: Report a bug
Discussions: Join the conversation
Documentation: docs.whodb.com
⭐ 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.
Built with ❤️ by the Clidey team
"Is it magic? Is it sorcery? No, it's just WhoDB!"
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 sync415 npm31-
- 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.480MIT
- 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