DEDUPED Hot AI repos, turned into use cases Get the Monday 5

How to generate dashboard SQL from a read-only database schema with Harnessrouter

Use the Dashboards starter kit to have a harness write chart queries from your schema.

Credentials. The database connection stores credentials, so use a read-only account and set HR_SECRET_KEY first.

Who it is forA data analyst who wants dashboard charts built from a database without writing each SQL query by hand.

The problemWriting dashboard queries for every chart takes time, and the schema has to be read first.

The outcomeA harness reads your schema and writes SQL that powers dashboard charts.

What you need first

  • Docker installed
  • About 4 GB of free disk space
  • A provider API key for at least one supported model provider
  • Python 3 if you use the Idempotency-Key example

Steps

  1. Complete setup and open Starter Kits in the Console
  2. Set HR_SECRET_KEY to encrypt stored database connections
  3. Connect a reachable database using a read-only account
  4. Review the sample-row setting before you connect
  5. Select a harness and model supported by your connected providers and run the Dashboards kit

Prompt for your agent

Using the HarnessRouter repo at https://github.com/HarnessRouter/harnessrouter, connect a read-only database <db-connection> in the Dashboards starter kit and ask the harness to write queries for <chart-list>. Expected output: SQL queries that run against the schema. Verify each query runs on the read-only account before reporting them as ready.

Caveat. The README says Starter Kits use different licensing terms, so review those terms before using the kit commercially.

Use this in your AI agent

Ask your agent

Using the Deduped MCP, get the setup steps for HarnessRouter/harnessrouter and "Generate dashboard SQL from a read-only database schema"

Add Deduped to Claude Code once

claude mcp add --transport http deduped https://dedupedai.com/mcp

Cursor, ChatGPT, others

Share: X LinkedIn Hacker News Email Copy link

Third-party repos we don't own. AI-written use cases can be wrong. Disclaimer