The SQLite query console

Run SQLite SQL, inspect the query plan as a tree and export local results with the source limitations shown in the form.

SQLite over SSH has been requested in other tools since 2023, with 45 votes.

The SQLite query console runs SQL against the selected database file or remote source and displays the result in a grid. It is useful for joins, pragmas, schema inspection and statements that need more control than a table filter.

Run and inspect

  1. Open the query console for the connection.
  2. Write SQL in the editor.
  3. Run the current statement with Ctrl+Enter.
  4. Inspect the returned rows and columns before staging a separate grid edit.

The query result can be exported through the shared result workflow. Shift+Enter opens a selected cell value, and Ctrl+F searches the active editor or result surface.

Read the query plan

SQLite’s query-plan workflow presents the plan as a tree. Use it to check scans, indexes and the order of operations. Run the same query again after adding or changing an index and compare the tree rather than relying only on elapsed time.

The query console keeps DDL in SQL. SQLite has no visual DDL, import or dump workflow in this surface.

Remote limitations

For Turso / libSQL and Server over SSH, the form shows no manual transaction in the console, no export to file and no File panel. Grid, editing and console work. Local files use the local export workflow.

A query that changes data should still use the connection’s safe mode and be reviewed before execution. Grid edits have the separate row-token check described in safe mode and review.