patom
Interact with Postgres from within Atom
zchr 270 0 1.2.0 MIT GitHub

Patom

This is an Atom package that lets you interact with Postgres databases from within Atom.

Quick note: I threw this together as a side project, mainly so I could interact with my local PG. This was not made with scale/security in mind, so please be careful. It handles auth with node-postgres.

Typing SQL and seeing results with autocomplete


What it does

It's pretty simple. Highlight some code in Atom and pres Cmd-1. Bam, output is in the dock below. It's got an impressively short list of features:

  • Save your connection across sessions
  • Autocomplete table names and columns
  • Set your own keyboard shortcuts, Cmd-3 through Cmd-5
    • Shortcuts all contain $$, which is where the highlighted SQL query will get inserted

Shortcuts pane

Save connection pane

All of these are manageable via the Packages > Patom menu.

The package talks to PG via node-postgres, so the makers and maintainers deserve a massive thanks.


License

MIT. Please submit issues slash feature requests, or consider opening a PR.