Skip to content
pg-sqill logo

pg-sqill

PostgreSQL database helper. Use when writing SQL queries, exploring schema, or working with the database.

NeverSight/skills_feed0installs214starsOther

SKILL.md

Full skill instructions

Database

The application uses PostgreSQL. Connection string is in DATABASE_URL environment variable.

To query the database directly:

export $(cat .env | xargs) && psql $DATABASE_URL -c "YOUR SQL"

Note: Table names with uppercase letters require double quotes (e.g., "Member", "Task").

Schema

-- Schema not synced. Run sync.sh in the scripts folder.

Tips

  • Use LIMIT 5 when exploring data
  • Check column names before writing queries
  • Join tables using foreign key relationships shown in schema