---
name: postgres
description: Manage PostgreSQL databases via the psql CLI.
metadata:
  displayName: PostgreSQL
  icon: postgres
  category: databases
  version: 1.0.0
  dependencies:
    cli: psql
    checkCommand: psql --version
    bundledInstall: skills/postgres/install.sh
    install:
      darwin:
        brew: postgresql
      linux:
        apt: postgresql-client
      windows:
        scoop: postgresql
  auth:
    type: none
---

# psql

Use `psql` to interact with PostgreSQL databases.

## Common Commands

### Connection

- Connect: `psql "postgresql://user:password@host:port/dbname"`

### Operations

- List databases: `\l`
- List tables: `\dt`
- Describe table: `\d <table_name>`
- Execute query: `SELECT * FROM table LIMIT 10;`
- Quit: `\q`

## Notes

- Requires `psql` to be installed in the environment.