Chat DB

Render Chart

USE CASE: RENDER A SINGLE CHART FROM A CHAT DASHBOARD. USE get_dashboard_info before using this tool to get the sql schema so that you can properly render a chart for this dashboard. Use the dashboards in the description to infer the app id for the dashboard the user is talking about, then get dashboard info with it to understand how to make a read-only SQL query to appropriately render a chart for the user. Execute a read-only SQL query against a ChatDB app and return structured data for the ch

Render Chart Gallery

USE CASE: RENDER A GALLERY OF MULTIPLE CHARTS FROM A CHAT DASHBOARD. Display 2–5 charts side by side in a horizontal layout using the ChatDB chart widget. Use the dashboards mentioned in the user’s request to infer the app id, then fetch dashboard info to determine the appropriate read-only SQL queries for each chart. Execute the necessary SELECT, WITH, or read-only PRAGMA queries against the ChatDB app and return structured data for the gallery display. Supports bar,verticalBar,histogram,line,a

Get Dashboard Info

USE CASE: UNDERSTAND HOW TO QUERY A DASHBOARD FOR RENDERING CHARTS or EXECUTING QUERIES. Get database schema information for a specific dashboard. Call this once per dashboard to understand its database structure before querying. Returns table schemas, column details, row counts, foreign key relationships, pinned/unpinned tables. Once you have this schema information for a dashboard, you can use it for multiple queries without calling this again. Typically, if the user mentions an app that is al

Find Available Dashboards

USE CASE: the user mentions a dashboard that is not already listed in the render_chart description. List all available dashboards for the authenticated user. Once you have the dashboard list, you typically only need to call this again if you need to refresh the list of available apps. Each app has a SQLite database that can be queried, and before querying or making a chart, get dashboard info to understand the sqlite table structure.

Create Dashboard

Create a new dashboard with complete metadata and database. This tool accepts the finished app description, starter question, visual identity, and SQL migrations produced by the MCP client. The database name is automatically generated from the provided dashboard name. The dashboard is created immediately with database setup. No starter query is executed during creation — the first time the app is opened, the UI automatically sends ‘what can I do with this dashboard via the normal streaming flow.

Query Dashboard

USE CASE: EXECUTE READ-ONLY SQL QUERIES DIRECTLY AGAINST A CHATDB DASHBOARD. USE get_dashboard_info before using this tool to retrieve table and column schema so that you can construct correct SQLite queries. Use the dashboards listed in the description to infer the app ID that the user is referring to, then run queries using this tool. Supports multiple sequential SELECT, WITH, or read-only PRAGMA queries in one request. Returns Markdown tables for each query along with execution metadata. T