Quantstrip docs
Open Dashboard
Docs / Dashboard Apps / Database / SQL
Dashboard Apps

Database / SQL

A free-text SQL editor against Quantstrip's own SQLite database — the same database every other page and every strategy client reads and writes through.

SQL editor with query results table, schema tree, and saved-query file browser
assets/screenshots/sql_database_editor.png Screenshot not yet added — drop the file above into docs/assets/screenshots/ and it will appear here automatically.
Database / SQL — query editor

Editor

The main panel is a code editor in SQL mode. Query text is passed directly to DBHandler.run_query, the same method used by other pages and client scripts. SELECT statements render results as a table below the editor; results can be exported to CSV.

There is no read-only mode and no confirmation step for destructive statements. INSERT, UPDATE, DELETE, and DROP all execute immediately as typed, equivalent in effect to a raw sqlite3 shell against the production database.

Saved queries

A file-tree panel alongside the editor organizes .sql files in folders: New File, New Folder, Open, Save, Save As, and Delete. There is no query-history feature; a query must be saved explicitly to be kept.

Schema browser

A separate tree panel shows the database schema (tables and columns), generated directly from the live database rather than maintained separately.

For the same query capability from a strategy script, see the database API reference for run_query and the higher-level order/execution/position methods built on it.