SQLite browser

Opening a database

1. Open the Database tab.
2. Pick a project from the dropdown. Stratos looks for database/database.sqlite at the project root.
3. Connected! The sidebar lists every table with its row count.

Browsing a table

Click a table, then click Load Data. The schema and the first 50 rows render in a grid. Click a column header to copy the value.

Running queries

Switch to the SQL tab. The editor accepts SELECT, PRAGMA, and WITH statements. The connection is opened in read-only mode, so write attempts are rejected by SQLite itself — there is no way to mutate the database from this view, even with creative syntax.

Useful queries

-- Inspect the schema
SELECT name, sql FROM sqlite_master WHERE type='table';

-- Count users created in the last week
SELECT COUNT(*) FROM users WHERE created_at > datetime('now', '-7 days');

-- Find duplicate emails
SELECT email, COUNT(*) AS n FROM users GROUP BY email HAVING n > 1;

Limits

Up to 500 rows are returned per query. BLOB columns are shown as ?; click the cell to copy the raw hex.