with one click
data-exploration
Systematic database and table profiling for DBX Studio. Use when a user wants to understand their data, explore schema structure, or profile a dataset.
Menu
Systematic database and table profiling for DBX Studio. Use when a user wants to understand their data, explore schema structure, or profile a dataset.
| name | data-exploration |
| description | Systematic database and table profiling for DBX Studio. Use when a user wants to understand their data, explore schema structure, or profile a dataset. |
Start with read_schema to list all tables, then describe_table for each table of interest.
1. read_schema(schema_name: "public")
2. describe_table(table_name: "<each table>")
3. get_table_stats(table_name: "<table>")
For each table, gather:
get_table_dataLook for foreign key patterns:
*_id linking to other tablesusers.id → orders.user_id| Score | Completeness |
|---|---|
| Green | > 95% populated |
| Yellow | 80–95% populated |
| Orange | 50–80% populated |
| Red | < 50% populated |
SELECT COUNT(*) AS row_count FROM "public"."table_name";
SELECT
COUNT(*) AS total,
COUNT(column_name) AS non_null,
ROUND(100.0 * COUNT(column_name) / COUNT(*), 2) AS pct_filled
FROM "public"."table_name";
SELECT column_name, COUNT(*) AS frequency
FROM "public"."table_name"
GROUP BY 1
ORDER BY 2 DESC
LIMIT 20;
SELECT MIN(created_at), MAX(created_at) FROM "public"."table_name";
After exploration, present a structured summary: