Planetsheet NPM

Planetsheet

A SQL editor designed for developers and content editors.

Today, Planetsheet is an (early) alternative to npx prisma studio, Postico, and TablePlus. See todos for missing features. File an issue to suggest new ideas.

In the future, Planetsheet will give you (and your content editors) an interface as intuitive as Airtable and Google Sheets, while letting you (as a developer) use powerful databases underneath.

Usage

npx psheet

Make sure the DATABASE_URL environment variable is defined. Planetsheet should just work. If it doesn't, please file an issue!

Supported Databases

Postgres
MySQL
SQLite (coming soon)

Sample connection strings

Currently, Planetsheet uses simple custom heuristics to add SSL query parameters for common database providers.

Planetscale

DATABASE_URL=mysql://0qnpifrkjmwv:pscale_pw***********************@asdfojklae.r.us-west-2.psdb.cloud/show?ssl=true

Supabase

DATABASE_URL=postgresql://postgres:[YOUR-PASSWORD]@db.eegtiwadasfjibedlgk.supabase.co:5432/postgres

Neon.tech

DATABASE_URL=postgres://lawrencecchen:[YOUR-PASSWORD]@prowl-read-4122469.cloud.neon.tech:5432/main?sslmode=require

Common errors

`npx psheet` terminates early

There's likely another process running on port 58337. Inspect using lsof -i tcp:58337 and kill the suspecting process.

Cannot connect

Planetsheet uses knex internally. Look up how to connect to your database with your database's SSL settings.

Development

npm install
npm run dev

Deployment

npm run build

Currently, Planetsheet is only tested with npx psheet. In the future, there should be a straighforward path towards self-hosting (Vercel/Railway/Docker).

Todos

bottom action bar
- content/structure/ddl
query editor
- query history
redirect to /app/db when table/schema not found
better error handling
image previews
- image uploads (configurable to cloudflare, s3, supabase s3, etc.)
relation selector
save database credentials
- store db credentials in keychain. what's the windows/linux analogous service??
automatically kill other processes on port 58337?
sort user tables to top; move system tables into another accordion

Future

Use Bun to bundle a standalone executable. Should have faster start up times, and (hopefully) ditch the hacky stuff happening in cli/cli.ts. Will also let us ditch node's sqlite3 + @mapbox/node-pre-gyp.

postgres mysql