pg-studio

library1.2.4jsnpmunverified

PG Studio is a lightweight, browser-based graphical interface for PostgreSQL databases, built with Next.js. Current version 1.2.4 is stable with a simple setup: run 'npx pg-studio' and it auto-launches the UI on localhost:3000. It requires no global install and reads connection strings from environment variables like DB_URL, DATABASE_URL, or PG_URL. It differentiates from tools like pgAdmin by being a zero-config, single-command tool ideal for quick database browsing and querying. The project is open-source under MIT and welcomes contributions.

database

npm install pg-studio

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · PG-STUDIO

pg-studio

databasejavascriptv1.2.4

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Run PG Studio directly without installation. Ensure a .env file with DB_URL or similar connection string exists in the current directory.

npx pg-studio

Debug

Known issues

gotchaNo .env file present? PG Studio will fail to start without a database connection string. The tool reads from environment variables, not command-line arguments.

fix

Create a .env file in the directory you run the command and set at least one of DB_URL, DATABASE_URL, PG_URL, POSTGRES_URL, PG_CONNECTION, or CONNECTION_STRING.

affects: >=1.0

Errors

Common errors & fixes

Error: No database connection found. Please set DB_URL or DATABASE_URL in your .env file.

Missing or invalid environment variable for connection string.

fix

Add a valid connection string to .env, e.g., DB_URL=postgres://user:pass@localhost:5432/mydb

Upgrade

Version history

1.2.4latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

2 hits · last 30 days

node

Resources

githubhttps://github.com/Shanoof-t/pg-studio ↗

packagepg-studio ↗

homepagehttps://github.com/Shanoof-t/pg-studio#readme ↗