SQLPad saved SQL analyses

Start with the shared setup and dataset. The versioned observations below use the MatrixOne build identified in the overview.

Connect and save queries

SQLPad is an archived legacy tool; this guide is a compatibility reference for existing installations, not a recommendation to adopt it for a new production system. The tested version was 7.5.7.

  1. Install and initialize SQLPad following its archived upstream instructions, with an authenticated application user.

  2. Add a MySQL connection: host MO_HOST, port 6001, database bi_tutorial, username and password. Use the driver’s supported SSL settings where required.

  3. Execute SELECT 1, then run the shared category query and check A=130.000000, B=280.000000.

  4. Save it as Net amount by category, reopen the saved query and execute again. Add separate saved queries for total KPIs and daily/running totals. These are SQL definitions; SQLPad does not provide the native metric-object workflow used in Metabase or Rill.

Native API and result completeness

The tested REST connection configuration used keys driver: "mysql", host, port, database, username and password. Authenticated requests created a connection using /api/connections, and saved query text using /api/queries with name, connectionId and queryText.

For execution, POST /api/batches accepts:

{
  "connectionId": "SAVED_CONNECTION_ID",
  "batchText": "SELECT COUNT(*) FROM bi_tutorial.order_metrics",
  "maxRows": 100000
}

Wait for the batch status to finish and inspect the statement error and incomplete flag before reading /api/statements/{statementId}/results. A successfully submitted batch is not a completed successful query. The test also configured SQLPAD_QUERY_RESULT_MAX_ROWS=100000; requested and server limits must both be checked.

Native REST batches returned all expected rows, and saved-query retrieval/re-execution was verified. This does not establish a semantic layer or browser chart/dashboard coverage. Use the shared Decimal and row-count checks when upgrading drivers or changing result limits.