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

How to send a scheduled morning report from a SQL database with Apowerb

A scheduled agent asks the database in plain language and mails the summary.

Authorization notice. Apowerb is dual-use. Only use it on software, sites and systems you own or have explicit permission to test.

Credentials. The database login used by the agent should be read-only, since generated SQL runs against live data.

Who it is forA manager who wants the same daily numbers in the inbox each morning without writing queries.

The problemDaily figures live in a database, and someone has to write the query, make a chart and send it every day.

The outcomeAn agent runs on a schedule, turns a plain-language question into SQL, and mails a summary with a chart.

What you need first

  • Docker and Docker Compose
  • An API key from a supported model provider such as Anthropic, OpenAI, Mistral, Gemini, Azure AI Foundry or OVHcloud, or any other LiteLLM provider
  • Accounts for the business systems you want to connect, such as Gmail, Outlook, HubSpot, Pipedrive or Odoo

Steps

  1. Start the stack: docker compose -f docker-compose/docker-compose.yml --env-file .env up -d
  2. Add your SQL database as a tool so the agent can run Text-to-SQL against it.
  3. Define an agent that asks the question in plain language, builds a chart and writes the summary.
  4. Set the cron schedule for the run, which the README says is driven by an external orchestrator. (inferred, check the README)
  5. Run the agent once by hand and check the session trace before the first scheduled send.

Prompt for your agent

Using the apowerb repo at https://github.com/apowerb/apowerb, create a scheduled agent that answers <business question> against <target database> with Text-to-SQL and mails a summary with a chart. Expected output: one email with the summary and chart. Verify the generated SQL in the session trace matches the question.

Caveat. The README does not say how the external orchestrator is set up, so the scheduling step needs to be confirmed in the docs before relying on it.

Use this in your AI agent

Ask your agent

Using the Deduped MCP, get the setup steps for apowerb/apowerb and "Send a scheduled morning report from a SQL database"

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