postgres

Run PostgreSQL queries and admin tasks via the psql CLI.

16|2|Updated Jan 15, 2026
One-click install
npx skills add https://github.com/kubiyabot/skill --skill postgres-kubiyabot
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: postgres
Source: https://github.com/kubiyabot/skill/tree/main/examples/native-skills/postgres-skill
Command: npx skills add https://github.com/kubiyabot/skill --skill postgres-kubiyabot

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables PostgreSQL database operations via the native psql CLI from an agent that runs locally.

Core Features & Use Cases

  • Query the database and return results in the requested format (table, csv, json, or html).
  • Inspect schemas, tables, columns, indexes, constraints, and sizes to support maintenance and auditing.
  • Admin tasks: create/drop databases, manage users, grant privileges, and perform backups/restores with built-in safety checks.

Quick Start

Use the skill to run a simple query or inspect a database. For example, run the query tool to get the PostgreSQL version: skill run postgres:query --sql "SELECT version();" --format table

Frequently Asked Questions about postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run PostgreSQL database queries from a local agent?

You can run PostgreSQL queries from a local agent using native psql CLI commands. The skill executes SQL statements and returns results in table, csv, json, or html formats via a consistent interface.

How do I inspect PostgreSQL schemas and tables for maintenance?

Inspect PostgreSQL schemas and tables by querying metadata through psql. The skill examines tables, columns, indexes, constraints, and sizes to support database maintenance and auditing tasks.

Can I perform PostgreSQL backup and restore operations via psql CLI?

Yes, you can perform PostgreSQL backup and restore operations via psql CLI. The skill manages backups and restores with built-in safety checks that enforce security rules for destructive database operations.

Does this PostgreSQL CLI tool support configurable host and port authentication?

Yes, this PostgreSQL CLI tool supports configurable host and port authentication. It validates identifiers to prevent injection while connecting to databases using custom credentials across different environments.

What are the limitations when running destructive PostgreSQL administration tasks?

Destructive PostgreSQL administration tasks are limited by enforced security rules. The skill validates identifiers to prevent injection and applies built-in safety checks before executing operations like dropping databases or revoking privileges.