whodb_schemas
List all database schemas to discover namespace organization. Optionally retrieve tables within each schema in a single call.
Instructions
List all schemas (namespaces) in a database.
Best for: Discovering what schemas exist in a database; understanding database organization before exploring tables. Not recommended for: When you already know the schema name (proceed directly to whodb_tables). Common mistakes: Calling this repeatedly - schema lists rarely change during a session.
Usage Example:
{
"name": "whodb_schemas",
"arguments": {
"connection": "mydb"
}
}Returns: Array of schema names (e.g., ["public", "analytics", "audit"]). Typical workflow: whodb_schemas → whodb_tables(include_columns=true) → whodb_query
Optional parameter: Set "include_tables": true to also return all tables within each schema in a single call. This populates a "details" array with schema names and their tables, saving you a separate whodb_tables call per schema.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Connection name (optional if only one exists) | |
| include_tables | No | Set true to also return tables within each schema in a single call |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schemas | Yes | ||
| details | No | ||
| error | No | ||
| request_id | No |