{"id":43587,"library":"pg-studio","title":"PG Studio","description":"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.","status":"active","version":"1.2.4","language":"javascript","source_language":"en","source_url":"https://github.com/Shanoof-t/pg-studio","tags":["javascript","pg","psql","postgresql"],"install":[{"cmd":"npm install pg-studio","lang":"bash","label":"npm"},{"cmd":"yarn add pg-studio","lang":"bash","label":"yarn"},{"cmd":"pnpm add pg-studio","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[],"quickstart":{"code":"npx pg-studio","lang":"javascript","description":"Run PG Studio directly without installation. Ensure a .env file with DB_URL or similar connection string exists in the current directory."},"warnings":[{"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.","message":"No .env file present? PG Studio will fail to start without a database connection string. The tool reads from environment variables, not command-line arguments.","severity":"gotcha","affected_versions":">=1.0"}],"env_vars":null,"search_vec":"'1.2.4':21 '3000':42 'auto':36 'auto-launch':35 'base':10 'brows':83 'browser':9 'browser-bas':8 'built':16 'command':77 'config':74 'connect':50 'contribut':96 'current':19 'databas':15,58,82 'db':56 'differenti':64 'environ':53 'global':46 'graphic':11 'ideal':79 'instal':47 'interfac':12 'javascript':97 'launch':37 'lightweight':7 'like':55,67 'localhost':41 'mit':93 'next.js':18 'npx':29 'open':90 'open-sourc':89 'pg':1,3,31,61,98 'pg-studio':30 'pgadmin':68 'postgresql':14,100 'project':87 'psql':99 'queri':85 'quick':81 'read':49 'requir':44 'run':28 'setup':27 'simpl':26 'singl':76 'single-command':75 'sourc':91 'stabl':23 'string':51 'studio':2,4,32 'tool':66,78 'ui':39 'url':57,59,62 'variabl':54 'version':20 'welcom':95 'zero':73 'zero-config':72","created_at":"2026-06-05T17:00:31.345120+00:00","updated_at":"2026-06-05T17:00:31.345120+00:00","problems":[{"fix":"Add a valid connection string to .env, e.g., DB_URL=postgres://user:pass@localhost:5432/mydb","cause":"Missing or invalid environment variable for connection string.","error":"Error: No database connection found. Please set DB_URL or DATABASE_URL in your .env file."}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/Shanoof-t/pg-studio#readme","github":"https://github.com/Shanoof-t/pg-studio","docs":null,"changelog":null,"pypi":null,"npm":"pg-studio","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}