The SQLite file in your project, as tables.
midcode is adding a table editor and a SQL editor for SQLite. It finds the .db, .sqlite or .sqlite3 file your project keeps in the usual places (the root, prisma/, db/, data/, database/, storage/), shows its tables with their rows, and runs the SQL you write on it. It’s a file on your Mac, so there’s no server to start and nothing to connect.
v1.1.2This is being built and isn’t in the version you download today. Leave your email to hear when it ships.
- Status
- In development
- Finds
- .db, .sqlite and .sqlite3 files
- Server
- None
- Setup
- None
01/What you can do
What’s coming for SQLite.
Open the file, see the tables
The development database of a Prisma, Drizzle, Laravel or Django project, without installing a database browser.
A SQL editor
Write a query, run it, read the result as a table. Queries you save are kept with the project.
Warnings that matter
An UPDATE or DELETE with no WHERE tells you it touches every row, and asks before it runs.
Next to the page it feeds
Run a query, look at the canvas: the data and the page that reads it share a window.
02/How it works
Three steps. No new workflow.
Step 1: Open your project
midcode looks for the database the project already points at. Connection strings stay in the app’s main process and are never shown.
Step 2: Browse and query
Open a table to read its rows, or write SQL and run it. Save the queries you’ll want again.
Step 3: Allow changes when you mean to
A database on your Mac can be changed. One that isn’t opens read-only until you turn on “Allow changes”.
03/Good to know
The honest part.
What it doesn’t do
- Changes to a database have no undo and aren’t part of Publish.
Coming next
- Turso.
04/FAQ
SQLite questions. Short answers.
No. midcode reads the file itself.
It’s being built now. The email list at the bottom of this page is told first.
05/Goes with
The rest of your stack.
- In developmentPostgres. Your tables and a SQL editor, found from your .env.
- Next releaseLaravel. Blade views, edited on the canvas. With or without Vite.
- Next.js. App Router projects, edited in their .tsx files. Metadata and pages too.
- SvelteKit. SvelteKit and Vite + Svelte, edited in their .svelte files.
Be the first to use it with SQLite.
midcode already edits your site on a live canvas. Download it now, and the data editors arrive as an update: every update is included.