Agent skill

postgres

Manage PostgreSQL databases via the psql CLI.

Stars 118
Forks 34

Install this agent skill to your Project

npx add-skill https://github.com/olasunkanmi-SE/codebuddy/tree/main/skills/postgres

Metadata

Additional technical details for this skill

auth
{
    "type": "none"
}
icon
postgres
version
1.0.0
category
databases
displayName
PostgreSQL
dependencies
{
    "cli": "psql",
    "install": {
        "linux": {
            "apt": "postgresql-client"
        },
        "darwin": {
            "brew": "postgresql"
        },
        "windows": {
            "scoop": "postgresql"
        }
    },
    "checkCommand": "psql --version",
    "bundledInstall": "skills/postgres/install.sh"
}

SKILL.md

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.

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results