— name: whodb description: Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, TiDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases. — # WhoDB Database Assistant You have access to WhoDB for database operations. Use these tools and commands to help users with database tasks. ## MCP Tools (Preferred) When the WhoDB MCP server is available, use these tools directly: ### whodb_connections List all available database connections. “` No parameters required. Returns: List of connection names with type and source (env/saved). “` ### whodb_query Execute SQL queries against a database. “` Parameters: – connection: Connection name (optional if only one connection exists) – query: SQL query to execute Example: whodb_query(connection="mydb", query="SELECT * FROM users LIMIT 10") “` ### whodb_schemas List all schemas in a database. “` Parameters: – connection: Connection name (optional if only one connection exists) Example: whodb_schemas(connection="mydb") “` ### whodb_tables List all tables in a schema. “` Parameters: – connection: Connection name (optional if only one connection exists) – schema: Schema name (optional, uses default if not specified) Example: whodb_tables(connection="mydb", schema="public") “` ### whodb_columns Describe columns in a table. “` Parameters: – connection: Connection name (optional if only one connection exists) – table: Table name (required) – schema: Schema name (optional) Example: whodb_columns(connection="mydb", table="users") “` ## CLI Commands (Fallback) If MCP tools are unavailable, use the CLI directly via Bash: ### Query Execution “`bash whodb-cli query "SELECT * FROM users LIMIT 10" –connection mydb –format json “` ### Schema Discovery “`bash # List schemas whodb-cli schemas –connection mydb –format json # List tables whodb-cli tables –connection mydb –schema public –format json # Describe columns whodb-cli columns –connection mydb –table users –format json “` ### Connection Management “`bash # List connections whodb-cli connections list –format json # Test connection whodb-cli connections test mydb # Add new connection (interactive) whodb-cli connections add –name mydb –type Postgres –host localhost –database mydb “` ### Data Export “`bash # Export to CSV whodb-cli export –connection mydb –table users –output users.csv # Export query results whodb-cli export –connection mydb –query "SELECT * FROM orders" –output orders.xlsx “` ## Workflow Examples ### Explore a New Database 1. List connections: `whodb_connections` 2. List schemas: `whodb_schemas(connection="name")` 3. List tables: `whodb_tables(connection="name", schema="public")` 4. Describe table: `whodb_columns(connection="name", table="users")` 5. Sample data: `whodb_query(connection="name", query="SELECT * FROM users LIMIT 5")` ### Answer Data Questions 1. Understand the schema first – check table structure 2. Write targeted queries with appropriate filters 3. Always use LIMIT for exploratory queries 4. Present results in a clear, readable format ## Best Practices – **Always explore schema first** before writing queries – **Use LIMIT** for exploratory queries to avoid overwhelming output – **Prefer specific columns** over SELECT * for clarity – **Check foreign keys** via whodb_columns to understand relationships – **Use JSON format** (–format json) when parsing output programmatically – **Never expose credentials** – use connection names, not connection strings