Use Case Guides

API Development

WhoDB is useful when you are building or debugging an API layer on top of a database and need fast visibility into schema shape, live data, and query behavior.

Note

This page is about APIs you build on top of your database. WhoDB's web backend is not documented as a supported public API for external integrations.

Where It Helps

Schema Inspection

Check tables, columns, relationships, and field types before you change your API contracts.

Query Prototyping

Use Scratchpad to validate the SQL behind new endpoints and compare result shapes quickly.

Seed And Fixture Data

Use the in-app import panel for CSV, Excel, or SQL scripts when you need repeatable local API test data.

Tool Integration

Use the CLI, and where appropriate the CLI MCP server, in local workflows and AI-assisted tooling.

Typical Workflow

Inspect The Schema

Use the schema explorer and graph view to verify table names, keys, and relationships before writing a new endpoint or query.

Prototype The Query

Use Scratchpad to iterate on joins, filters, and pagination logic before committing it to application code.

Check Real Data

Open the table view to confirm nullability, outliers, and the actual values your API will have to serialize.

Load Test Fixtures

Use the in-app import flow for CSV, Excel, and SQL scripts. Use whodb-cli import when you want to load CSV or Excel fixtures from a terminal.

Automate With MCP Or CLI

Use whodb-cli commands, or start whodb-cli mcp serve for local tooling that speaks MCP.

Scratchpad Introduction

Prototype queries before turning them into endpoint code.

CLI & MCP

Use the terminal client and MCP server in development workflows.

Importing Data

Load fixtures and sample data for endpoint validation.

Schema Explorer

Inspect tables and relationships before changing API contracts.

Debugging Production Issues

AI-Powered Data Exploration

API Development

Where It Helps

Typical Workflow

Related Pages