Skip to main content
SQL Planner

SQL Planner · Business Intelligence & Reporting

Turn your SQL databases into live dashboards and shareable reports.

Build charts, pivot tables and KPIs straight from SQL Server, PostgreSQL, MySQL, MariaDB, Percona, Amazon Aurora, Amazon Redshift and Oracle — driven by the parameters your users choose. No extra BI stack, no data copies. It runs where your data already lives.

9 engines

SQL Server · PostgreSQL · MySQL · Oracle & more

10+ visuals

charts · tables · pivots · KPIs

1 report

run it against many servers

One Place for Every Report

From raw SQL to a dashboard your whole team can read

Write a query, pick a chart, drop in a filter. The BI module handles the layout, the caching, the sharing and the scheduling — so a report you build once keeps working for everyone who opens it.

Capabilities

Everything you need to build and share reports

Rich visuals

Ten-plus widget types, each from a single query.

  • Bar, line, area & scatter
  • Pie, doughnut, polar & radar
  • Data tables with conditional formatting
  • Pivot matrix & big-number KPIs

Parameters & filters

Let viewers slice the whole report themselves.

  • Single and multi-select pickers
  • Dropdowns filled from your database
  • Filter, sort & Top-N per widget
  • Click-to-cross-filter across widgets

Shared datasets

Write a query once and reuse it everywhere.

  • Named, connection-bound queries
  • Swap a widget to a dataset in one click
  • Update centrally, every report follows

Pivot matrix

Cross-tab any result into rows and columns.

  • Multi-level row groups
  • Column headers from your data
  • Sum, count, average, min or max

Multi-server runs

One report, pointed anywhere you need.

  • "Run against" any connection on the fly
  • Same query, different server
  • Perfect for health checks across estates

Export & embed

Get the numbers out in the format people want.

  • Excel, CSV, PDF & PNG
  • Clean read-only viewer
  • Cached for fast repeat loads
  • BI Builder

  • Report Canvas

  • Report Center

  • View Report

Organize & Govern

Keep reports tidy — and in the right hands

Folders & permissions

Group reports into folders and decide, per user and per folder, who can view, create, edit or delete. Owners keep control of their own work; admins see everything.

  • Per-folder access grid
  • Move reports between folders
  • Card-based report browser

Share & schedule

Send a report to people who never open the builder. Create a view-only link (optionally passcode-protected), or schedule email delivery so the numbers arrive on their own.

  • Link sharing, no sign-in needed
  • Recurring email subscriptions
  • Duplicate & export/import as templates

How It Works

Three steps to a shared dashboard

  1. 01

    Connect & query

    Point a widget at a connection and write plain SQL — or reuse a shared dataset. Parameters go in as @Name.

  2. 02

    Design the report

    Pick chart types, arrange widgets on the canvas, add filters and a pivot or KPI, and set the theme and row limits.

  3. 03

    Share & schedule

    File it in a folder, grant access, publish a link or schedule email — and run it against any server whenever you need.

At a Glance

The complete feature set

  • Drag-and-drop builder with a resizable widget canvas.
  • Ten-plus visuals — bar, line, area, scatter, pie, doughnut, polar, radar, table, matrix, KPI, separator.
  • Parameters — single & multi-select, with database-driven lookups.
  • Shared datasets — reusable, centrally-managed queries.
  • Filter, sort & Top-N plus calculated fields and conditional formatting.
  • Cross-filtering — click a chart to filter the rest.
  • Pivot matrix with multi-level rows and column headers.
  • Folders with a card-based browser and per-user permissions.
  • Share links — view-only, optional expiry and passcode.
  • Email subscriptions — scheduled, recurring delivery.
  • Run against — execute one report against many servers.
  • Templates — duplicate, or export/import a report as JSON.
  • Usage analytics — see who ran what, with drill-down.
  • Export to Excel, CSV, PDF and PNG.
  • Configurable row limits per report for large tables.
  • Runs on your infrastructure — your data never leaves your database.

Trusted by teams that run critical database environments

  • Liebherr Group logo
  • Simple Logic logo
  • Hanu logo
  • Lattice logo
  • Pacific National logo
  • Access Meditech logo
  • Simegh Technology Solutions logo

Ready to report from where your data lives?

Build live dashboards without an extra BI stack.

Get started free or request a demo — charts, pivots, KPIs and scheduled delivery, running against the databases you already have.