Why Real-Time Dashboards Matter
Static reports become stale the moment they are generated. Real-time dashboards keep your team aligned on the latest numbers, reducing the lag between data availability and decision-making. For operations teams, even a few minutes of latency can mean missed SLAs or delayed incident response.
Connecting PostgreSQL
Start by providing AI for Database with a read-only PostgreSQL connection string. The system introspects your schema, catalogs tables, views, and materialized views, and indexes column types and relationships. This metadata powers both natural language queries and dashboard widgets.
Creating Your First Widget
Ask a question like "Show daily active users for the past 30 days as a line chart." The system generates the query, fetches the data, and renders a chart. Click "Pin to Dashboard" to save it. Repeat for each metric you want to track.
Configuring Refresh Intervals
Each widget can have its own refresh interval. High-frequency metrics like active sessions might refresh every 30 seconds, while slower-moving KPIs like monthly revenue can refresh hourly. The system uses PostgreSQL's query planner to estimate cost and warns you if a refresh interval would place excessive load on your database.
Sharing and Embedding
Dashboards can be shared via link, embedded in internal tools with an iframe, or pushed to Slack channels on a schedule. Access controls ensure that only authorized users can view sensitive data.