Manage your PostgreSQL databases directly in your browser.
Tool written using Node.js on the backend and React on the frontend. Current features include:
- Tables structure (columns & indexes)
- Tables rows
- Views
- SQL query execution
- Database export
- SQL file import
npm install -g pg-pilot
You may need to run the command above as sudo (based on your system settings).
pg-pilot
It runs by default on the port 8080. You can easily change that behavior by appending the port to the command:
pg-pilot -p 3000
Upcoming features include:
- Edit table structure
- Delete table
- Delete view
- Add & edit row
Contributions are welcome as long as they include tests.
MIT