PG-Pilot

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

Installation

npm install -g pg-pilot

You may need to run the command above as sudo (based on your system settings).

Usage

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

Roadmap

Upcoming features include:

• Edit table structure
• Delete table
• Delete view
• Add & edit row

Contributions are welcome as long as they include tests.

Licence

MIT