# The reports you need.  

> Automate SQL reports with DRE: finance Excel workbooks, fixed-width bank files, cloud extracts and Slack messages. Inspect SQL, YAML and real outputs.

The projects behind them.

DRE automates recurring SQL reports and their delivery. Find the job closest to yours, inspect its SQL and YAML, and see what it produces.

[Try complete example projects](https://getdre.com/examples/)

## Recurring reports and delivery

[

### Trustworthy AI with MCP

Reviewed report answers, local refinements and documented table exploration, with clear provenance.

Inspect the example](https://getdre.com/use-cases/trustworthy-ai-with-mcp/)[

### Monthly finance pack

A multi-sheet Excel workbook with money formats, formulas, totals and a branded template.

Inspect the example](https://getdre.com/use-cases/monthly-finance-pack/)[

### A file for a bank or regulator

Fixed-width or delimited files to the exact layout the other side asks for, dropped on SFTP.

Inspect the example](https://getdre.com/use-cases/file-for-a-bank/)[

### Extracts to S3, GCS or Azure Blob

Parquet or csv extracts, written where downstream systems pick them up.

Inspect the example](https://getdre.com/use-cases/extracts-to-object-storage/)[

### One report per store or region

Sets run the same report once per client, each with its own file and recipient.

Inspect the example](https://getdre.com/use-cases/one-report-per-store-or-region/)[

### DRE as a Databricks job

Install DRE from a wheel in a serverless job and write the report to a Volume.

Inspect the example](https://getdre.com/use-cases/databricks-job/)[

### One workbook from three systems

DuckDB, Postgres and Databricks tabs in one Excel file, each query on its own connection.

Inspect the example](https://getdre.com/use-cases/one-workbook-three-systems/)[

### A report built by a coding agent

From “help me with dre” to a delivered file, with an agent as the guide.

Inspect the example](https://getdre.com/use-cases/built-by-a-coding-agent/)[

### See every upcoming run

dre schedule ls lists when every schedule fires, with DST worked out, and the exact command for each run.

Inspect the example](https://getdre.com/use-cases/see-every-upcoming-run/)[

### A headline in Slack, the workbook attached

The numbers people actually read, posted to a channel, built from the same queries as the Excel file.

Inspect the example](https://getdre.com/use-cases/daily-headline-to-slack/)

## Formats, templates and reporting recipes

[

### Save to a Databricks Volume or workspace

Write the file to a Unity Catalog Volume or a workspace folder, from your laptop or inside a job.

Inspect the example](https://getdre.com/use-cases/databricks-volume-and-workspace/)[

### Run by schedule name

Name a timing once and share it; your orchestrator runs dre run --schedule, and a rerun renders the same SQL.

Inspect the example](https://getdre.com/use-cases/run-by-schedule-name/)[

### Deliver to many destinations in one run

One workbook: local copy, SFTP, S3, GCS, Azure Blob and an email, in order, in a single run.

Inspect the example](https://getdre.com/use-cases/deliver-to-many-destinations/)[

### Fill a branded Excel template

Design the workbook in Excel; DRE fills the cells and tables and keeps your styling.

Inspect the example](https://getdre.com/use-cases/fill-an-excel-template/)[

### Totals, row formulas and column formulas

Real Excel formulas under and beside your data: totals for columns, a formula on every row, a formula over whole columns.

Inspect the example](https://getdre.com/use-cases/totals-and-formulas/)[

### Send a message only when it matters

A when: condition over the results: the message goes out only when a region is under target.

Inspect the example](https://getdre.com/use-cases/alert-only-when-it-matters/)

[Build your first report](https://getdre.com/docs/getting-started/)
