# WhoDB

> Connect, explore, query, edit, and visualize your databases with WhoDB Community.

This site publishes its MDX source. Fetch the .mdx links below for individual pages, or https://clidey.github.io/whodb/llms-full.txt for one combined text file. Start from this URL to discover documentation without guessing repository paths.

If this site is served by Dory's Node preview server, a read-only MCP endpoint is available at https://clidey.github.io/whodb/mcp. MCP clients require a one-time connection to that endpoint; the page URL alone is sufficient for clients that can browse these links.

## Documentation

- [Your databases, in one workspace](https://clidey.github.io/whodb/introduction.mdx): Explore, query, edit, and visualize your data with WhoDB Community.
- [Why WhoDB?](https://clidey.github.io/whodb/why-whodb.mdx): See how browsing, schema graphs, query notebooks, AI, and terminal tooling fit together.
- [Install and configure CE](https://clidey.github.io/whodb/installation.mdx): Run CE in Docker, as a binary, on the desktop, or from source; configure profiles and persistent sessions.
- [Connect your first database](https://clidey.github.io/whodb/first-login.mdx): Enter credentials, use a connection string, or select a configured profile.
- [Quick start](https://clidey.github.io/whodb/quick-start.mdx): Connect, inspect a schema, filter rows, run a query, and export an answer.
- [Move to WhoDB Platform](https://clidey.github.io/whodb/guides/move-to-platform.mdx): Bring your CE connection to WhoDB Platform and build data pipelines, operational apps, and an ontology.
- [Connect your sources](https://clidey.github.io/whodb/features/database-connectivity.mdx): Connect using credentials, parsed connection strings, profiles, TLS options, or local database files.
- [Discover cloud databases from the CLI](https://clidey.github.io/whodb/features/cloud-providers.mdx): List configured providers and discovered resources, then connect with the local CLI.
- [Inspect a schema](https://clidey.github.io/whodb/features/schema-explorer.mdx): Read object metadata, column types, and key relationships before querying.
- [Create tables and fields](https://clidey.github.io/whodb/features/schema-management.mdx): Define a new source object using the fields, types, and constraints supported by its connector.
- [Navigate the workspace](https://clidey.github.io/whodb/features/sidebar-navigation.mdx): Switch connections, schemas, and working views from the sidebar and command palette.
- [Browse tables and source objects](https://clidey.github.io/whodb/features/storage-units.mdx): Find tables, collections, and other source objects; inspect their structure or open their data.
- [Make the workspace yours](https://clidey.github.io/whodb/features/settings.mdx): Adjust appearance, data defaults, integrations, and privacy from Settings.
- [Ask questions about your data](https://clidey.github.io/whodb/ai/introduction.mdx): Use Chat to explore a connected source, inspect generated queries, and continue in Scratchpad.
- [Set up an AI provider](https://clidey.github.io/whodb/ai/setup-providers.mdx): Configure a remote or local model endpoint, discover models, and select one for Chat.
- [Query data with Chat](https://clidey.github.io/whodb/ai/querying-data.mdx): Ask a specific question, inspect its generated query, and refine the result.
- [Review changes proposed by Chat](https://clidey.github.io/whodb/ai/modifying-data.mdx): Inspect a generated statement before allowing it to change the connected database.
- [Keep a useful conversation](https://clidey.github.io/whodb/ai/conversation-features.mdx): Refine questions, manage chat sessions, and move generated queries into Scratchpad.
- [Browse and inspect rows](https://clidey.github.io/whodb/data/viewing-data.mdx): Use the data grid to inspect values, navigate results, and open row actions.
- [Add a record](https://clidey.github.io/whodb/data/adding-records.mdx): Create a row with the table form or a document with the source-specific editor.
- [Edit a record](https://clidey.github.io/whodb/data/editing-records.mdx): Edit cells inline or open the row editor, review pending changes, and verify the saved result.
- [Import data](https://clidey.github.io/whodb/data/importing.mdx): Preview CSV and Excel files, choose an import mode, or execute a reviewed SQL script.
- [Delete a record](https://clidey.github.io/whodb/data/deleting-records.mdx): Delete a focused row using the context menu and review the confirmation.
- [Find the right rows](https://clidey.github.io/whodb/data/filtering-searching.mdx): Use server-side conditions to filter results and Search to locate values in the loaded page.
- [Sort and page through data](https://clidey.github.io/whodb/data/sorting-pagination.mdx): Control row ordering and page size when browsing source data.
- [Scratchpad](https://clidey.github.io/whodb/query/scratchpad-intro.mdx): Investigate data with query pages, cells, inline results, and per-cell history.
- [Write and run queries](https://clidey.github.io/whodb/query/writing-queries.mdx): Execute an editor, a selection, or an individual statement and inspect its output.
- [Read query results](https://clidey.github.io/whodb/query/query-results.mdx): Inspect returned rows, distinguish action results from data, and export query output.
- [Reuse query history](https://clidey.github.io/whodb/query/query-history.mdx): Find successful and failed queries saved in each Scratchpad cell.
- [Organize pages and cells](https://clidey.github.io/whodb/query/multiple-cells.mdx): Keep investigations in named Scratchpad pages and separate related questions into cells.
- [Explore relationships in Graph](https://clidey.github.io/whodb/visualization/graph-view.mdx): Choose source objects, inspect their relationships, and open data from the graph.
- [Read a schema topology](https://clidey.github.io/whodb/visualization/schema-topology.mdx): Use a focused schema graph to understand a database before joining or changing data.
- [Understand table relationships](https://clidey.github.io/whodb/visualization/relationships.mdx): Interpret foreign-key edges and check the metadata behind a join.
- [Generate test data](https://clidey.github.io/whodb/advanced/mock-data.mdx): Populate a disposable object using append or overwrite mode.
- [Export data](https://clidey.github.io/whodb/advanced/export-options.mdx): Choose the rows and format you need: CSV, Excel, or supported JSON Lines.
- [Build WHERE conditions](https://clidey.github.io/whodb/advanced/where-conditions.mdx): Compose typed conditions in the grid and apply them to the database request.
- [Select rows and apply actions](https://clidey.github.io/whodb/advanced/batch-operations.mdx): Select the loaded records you need and use their supported context-menu actions.
- [Use WhoDB on your desktop](https://clidey.github.io/whodb/features/desktop-app.mdx): Work with native database file pickers, save dialogs, menus, and window persistence.
- [CLI and MCP](https://clidey.github.io/whodb/features/cli-and-mcp.mdx): Browse databases in a terminal, automate work, and connect assistants to local database tools.
- [MCP query permissions](https://clidey.github.io/whodb/features/mcp-permissions.mdx): Understand automatic reads, confirmation tokens, read-only mode, and connector enforcement.

## Guides

- [Start with your first database](https://clidey.github.io/whodb/guides/complete-beginner.mdx): Learn what WhoDB connects to and how to inspect data without writing a query first.
- [Move a MySQL workflow to WhoDB](https://clidey.github.io/whodb/guides/migrating-from-phpmyadmin.mdx): Recreate your MySQL browsing and query workflow without moving the database.
- [Move a PostgreSQL workflow to WhoDB](https://clidey.github.io/whodb/guides/migrating-from-pgadmin.mdx): Recreate your PostgreSQL browsing and query workflow without moving the database.
- [Set up CE for a team](https://clidey.github.io/whodb/guides/team-setup.mdx): Share a reachable workspace while keeping database permissions and profile access explicit.
- [Make a first connection](https://clidey.github.io/whodb/guides/tutorials/first-database-connection.mdx): Connect a PostgreSQL development database and verify the selected schema and table.
- [Explore an unfamiliar database](https://clidey.github.io/whodb/guides/tutorials/data-exploration-workflow.mdx): Go from object discovery to a filtered result and a repeatable query.
- [Build a query one step at a time](https://clidey.github.io/whodb/guides/tutorials/building-complex-queries.mdx): Inspect keys, test a join, aggregate results, and keep the intermediate queries.
- [Export an answer for analysis](https://clidey.github.io/whodb/guides/tutorials/data-export-analysis.mdx): Prepare a bounded result, export it, and record how it was produced.
- [Map a schema visually](https://clidey.github.io/whodb/guides/tutorials/schema-visualization.mdx): Choose related objects, inspect their fields, and export a focused diagram.
- [Ask your first question in Chat](https://clidey.github.io/whodb/guides/tutorials/ai-first-query.mdx): Configure a model, ask a bounded question, inspect the SQL, and keep the useful query.
- [WhoDB for developers](https://clidey.github.io/whodb/guides/roles/developers.mdx): Trace application state from schema to records, then keep a reproducible query.
- [WhoDB for data analysts](https://clidey.github.io/whodb/guides/roles/data-analysts.mdx): Inspect the source, define the metric, and export a result you can explain.
- [WhoDB for database administrators](https://clidey.github.io/whodb/guides/roles/database-administrators.mdx): Inspect metadata, troubleshoot access, and verify changes using browser and CLI tools.
- [WhoDB for QA testers](https://clidey.github.io/whodb/guides/roles/qa-testers.mdx): Prepare fixtures, inspect expected records, and compare results during testing.
- [Explore a database](https://clidey.github.io/whodb/use-cases/database-exploration.mdx): Understand an unfamiliar source using metadata, sample rows, filters, and relationships.
- [Analyze related data](https://clidey.github.io/whodb/use-cases/data-analysis.mdx): Build and verify an aggregate with source metadata, query cells, and export.
- [Prepare and inspect test data](https://clidey.github.io/whodb/use-cases/testing-development.mdx): Create disposable objects, load fixtures, and verify application state.
- [Validate a data migration](https://clidey.github.io/whodb/use-cases/data-migration.mdx): Use previews, counts, sample records, and queries to verify a planned data move.
- [Investigate production data](https://clidey.github.io/whodb/use-cases/debugging-production.mdx): Use a bounded read workflow and keep evidence that explains the incident.
- [Inspect the data behind an API](https://clidey.github.io/whodb/use-cases/api-development.mdx): Trace request identifiers into database records and verify state changes.
- [Explore with an AI assistant](https://clidey.github.io/whodb/use-cases/ai-data-exploration.mdx): Draft a query in Chat, inspect its meaning, and refine it with real source context.

## Best Practices

- [Secure a CE deployment](https://clidey.github.io/whodb/best-practices/security.mdx): Keep network access, database privileges, profiles, session storage, and model access explicit.
- [Keep browsing responsive](https://clidey.github.io/whodb/best-practices/performance.mdx): Use bounded pages, server-side filtering, and focused graphs for efficient investigation.
- [Keep data changes verifiable](https://clidey.github.io/whodb/best-practices/data-management.mdx): Inspect the target set, apply a deliberate change, and query the stored result.
- [Improve a query with evidence](https://clidey.github.io/whodb/best-practices/query-optimization.mdx): Measure one query, inspect its plan, and verify that a smaller result still answers the question.
- [Get useful answers from Chat](https://clidey.github.io/whodb/best-practices/ai-usage.mdx): Ask precise questions, inspect generated queries, and choose an appropriate provider.
- [Use WhoDB with PostgreSQL](https://clidey.github.io/whodb/best-practices/postgresql.mdx): Connect, inspect, and query PostgreSQL using the matching CE source workflow.
- [Use WhoDB with MySQL and MariaDB](https://clidey.github.io/whodb/best-practices/mysql.mdx): Connect, inspect, and query MySQL and MariaDB using the matching CE source workflow.
- [Use WhoDB with MongoDB](https://clidey.github.io/whodb/best-practices/mongodb.mdx): Connect, inspect, and query MongoDB using the matching CE source workflow.
- [Share reproducible database work](https://clidey.github.io/whodb/best-practices/collaboration.mdx): Share SQL, context, and diagrams while keeping browser-local workspace state in perspective.
- [Control database access](https://clidey.github.io/whodb/best-practices/access-control.mdx): Use database accounts and deployment boundaries to define what CE users can do.
- [Document a database investigation](https://clidey.github.io/whodb/best-practices/documentation.mdx): Keep diagrams, SQL, assumptions, and verification together in version control.

## Resources

- [Frequently asked questions](https://clidey.github.io/whodb/resources/faq.mdx): Answers about CE connections, profiles, query storage, exports, AI, and automation.
- [Troubleshoot a workflow](https://clidey.github.io/whodb/resources/troubleshooting.mdx): Find whether a failure comes from reachability, credentials, source capabilities, queries, or model setup.
- [Understand common failures](https://clidey.github.io/whodb/resources/common-errors.mdx): Match a visible failure to the next useful check.
- [Diagnose slow work](https://clidey.github.io/whodb/resources/performance-tuning.mdx): Separate database execution, network transfer, and browser rendering before changing settings.
- [Choose a database workflow](https://clidey.github.io/whodb/resources/comparisons/overview.mdx): Evaluate WhoDB using the tasks and sources that matter to you.
- [Evaluate WhoDB alongside phpMyAdmin](https://clidey.github.io/whodb/resources/comparisons/vs-phpmyadmin.mdx): Test the same connection, query, data editing, and export workflow in your chosen clients.
- [Evaluate WhoDB alongside pgAdmin](https://clidey.github.io/whodb/resources/comparisons/vs-pgadmin.mdx): Test the same connection, query, data editing, and export workflow in your chosen clients.
- [Evaluate WhoDB alongside DBeaver](https://clidey.github.io/whodb/resources/comparisons/vs-dbeaver.mdx): Test the same connection, query, data editing, and export workflow in your chosen clients.
- [Evaluate WhoDB alongside TablePlus](https://clidey.github.io/whodb/resources/comparisons/vs-tableplus.mdx): Test the same connection, query, data editing, and export workflow in your chosen clients.
- [Run CE with Docker](https://clidey.github.io/whodb/resources/integrations/docker.mdx): Give the container access to databases, files, and persistent session storage.
- [Run CE near an AWS database](https://clidey.github.io/whodb/resources/integrations/aws-deployment.mdx): Plan network reachability, TLS, profiles, and persistent storage for a CE deployment.
- [Use the CLI in CI](https://clidey.github.io/whodb/resources/integrations/ci-cd.mdx): Inspect disposable databases and keep structured verification output in a pipeline.
- [Observe a CE instance](https://clidey.github.io/whodb/resources/integrations/monitoring.mdx): Check process health, collect logs, and test source reachability separately.
- [Keep a real recovery path](https://clidey.github.io/whodb/resources/integrations/backup-tools.mdx): Distinguish row exports from complete database backups and verify restoration independently.
- [Keyboard shortcuts](https://clidey.github.io/whodb/resources/keyboard-shortcuts.mdx): Complete reference of WhoDB keyboard shortcuts for navigation, table actions, editing, and the Scratchpad
- [Workspace glossary](https://clidey.github.io/whodb/resources/glossary.mdx): The terms used across WhoDB Community and its source-aware interface.
- [Supported Databases](https://clidey.github.io/whodb/resources/supported-databases.mdx): Current Community Edition database catalog and compatibility families
- [Follow releases](https://clidey.github.io/whodb/resources/changelog.mdx): Find published versions, release notes, artifacts, and the current source.

## Other pages and translations

- [Enterprise Edition](https://clidey.github.io/whodb/resources/enterprise-edition.mdx): Overview of WhoDB Enterprise Edition capabilities and how EE differs from the open-source Community Edition