In-browser SQL editor

The Silos Console includes a SQL editor and playground that runs PGLite — real PostgreSQL compiled to WASM — directly in your browser. Queries execute client-side, so there's no provisioning step and no network round-trip to try things out.

What you can do

• Write and run arbitrary SQL — CREATE TABLE, INSERT, SELECT, transactions, the full standard surface.
• Prototype a schema interactively before deploying it to a Silos database.
• Explore data and iterate on queries with immediate, in-process results.

create table todos (
  id      serial primary key,
  title   text not null,
  done    boolean not null default false,
  created timestamptz not null default now()
);

insert into todos (title) values ('Try the Silos SQL editor'), ('Deploy to an edge database');

select * from todos where done = false order by created;

Because the engine is genuine Postgres, features like JSON/JSONB, CTEs, window functions, views, and PL/pgSQL work the same way they do on a deployed database.

create table events (id int, payload jsonb);
insert into events values (1, '{"kind":"click"}'), (2, '{"kind":"view"}'), (3, '{"kind":"click"}');

select
  payload->>'kind' as kind,
  count(*)         as n,
  rank() over (order by count(*) desc) as rnk
from events
group by payload->>'kind';

Editor vs. deployed database

Persisting your work

By default an in-browser database lives in memory for the session. To keep it across reloads, PGLite can persist to browser storage — see Persistence.

From editor to deployment

When your schema is ready, create a real database and apply it:

• Create a database in the Console or with the CLI.
• Connect with psql or your driver — see Connecting.