Can I connect to multiple PostgreSQL databases?

Yes. You can add multiple data sources and reference any of them in your dashboard queries. Each data source has its own credentials and connection settings, so you can pull data from several databases into a single dashboard.

Does the dashboard work with other databases besides PostgreSQL?

This guide focuses on PostgreSQL, but OpenClaw also supports MySQL, SQLite, and other SQL-compatible databases. The dashboard and visualization features work the same way regardless of the underlying database engine.

How do I limit who can see my dashboard?

Dashboard access is controlled through your RunTheAgent team settings. You can restrict the share link to specific team members or make it accessible to anyone with the link. Each viewer sees the same live data but cannot edit the queries or layout.

Data

Real-Time Dashboards: PostgreSQL + Visualization

Connect your PostgreSQL database to OpenClaw and build auto-refreshing dashboards with charts, tables, and live metrics you can share with your team.

Deploy OpenClaw See How It Works

What You Will Get

By the end of this guide, your OpenClaw agent will pull live data from your PostgreSQL database and display it as interactive charts, tables, and metric cards. You will have a dashboard that refreshes automatically on a schedule you choose, so your data is always current without manual work.

The dashboard supports multiple visualization types including line charts, bar charts, pie charts, and numeric summaries. Each widget connects to a specific SQL query, and you can arrange them in a grid layout that fits your workflow. Filters and date pickers let viewers drill into the data without editing queries.

Once your dashboard is configured, you can share a link with teammates or embed it in internal tools. Every viewer sees the same live data, and the agent handles query caching to keep your database load predictable even with many concurrent viewers.

Step-by-Step Setup

Follow these steps to connect PostgreSQL and build your first live dashboard.

Open the Data Sources Panel

Navigate to your OpenClaw agent on RunTheAgent and click the Data Sources tab. This panel lists all connected databases and APIs. Click Add Data Source and select PostgreSQL from the available options.

Enter Your Database Credentials

Provide your PostgreSQL host, port, database name, username, and password. RunTheAgent encrypts these credentials at rest. Click Test Connection to verify that your agent can reach the database before saving.

Create Your First Query

Open the Queries tab and click New Query. Write a SQL statement that fetches the data you want to visualize, such as daily revenue or active users over time. Use the preview button to see sample results and confirm the output columns match your expectations. Give the query a descriptive name so you can reference it later.

Add a Dashboard Widget

Switch to the Dashboards tab and create a new dashboard. Click Add Widget and choose a visualization type like Line Chart or Bar Chart. Link the widget to the query you just created, then map the output columns to the chart axes. Adjust colors and labels to make the chart easy to read at a glance.

Configure Auto-Refresh

In the dashboard settings, set a refresh interval. You can choose intervals from every 30 seconds to once per hour. The agent will re-run each query on schedule and update the widgets automatically. For high-frequency data, shorter intervals keep the display current without overloading your database.

Arrange the Layout

Drag and resize widgets on the dashboard grid to create a layout that highlights your most important metrics. Place key numbers at the top, detailed charts in the middle, and supporting tables at the bottom. Save the layout so it persists across sessions.

Share the Dashboard

Click the Share button to generate a view-only link. Send this link to teammates who need access. You can also embed the dashboard in other tools using an iframe. Permissions are managed through your RunTheAgent team settings, so you control who sees what.

Tips and Best Practices

Use Read Replicas for Heavy Queries

If your dashboard runs complex aggregations, point your data source at a read replica instead of your primary database. This prevents dashboard queries from competing with your application's write traffic and keeps both systems responsive.

Cache Expensive Queries

Enable query caching in the data source settings to avoid running the same expensive query for every viewer. A cache duration of 60 seconds works well for most dashboards and reduces database load significantly when multiple people view the dashboard simultaneously.

Add Date Filters to Every Dashboard

Include a date range picker on your dashboard so viewers can adjust the time window without editing SQL. This makes the dashboard flexible enough for both quick daily checks and deep monthly reviews.

Monitor Query Performance

Check the Logs tab on RunTheAgent to see how long each query takes. If a query consistently takes more than a few seconds, consider adding database indexes or rewriting the query to use more efficient joins and aggregations.

Frequently Asked Questions

Automated Visual Briefings KPI Monitoring: Alert on Threshold Breaches SQL Query Assistant

Ready to get started?

Deploy your own OpenClaw instance in under 60 seconds. No VPS, no Docker, no SSH. Just your personal AI assistant, ready to work.

Deploy OpenClaw View Pricing

Starting at $24.50/mo. Everything included. 3-day money-back guarantee.