skills.rest
pohlai88
pohlai88COMMUNITY
Explore all skills by this author →
GitHub

pg-sqill

Query PostgreSQL databases and explore table schemas using psql.

Updated Mar 5, 2026
Search Tags:#developer tools#database#postgresql#schema#sql#query
One-click install
npx skills add https://github.com/pohlai88/AFENDA --skill pg-sqill
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pg-sqill
Source: https://github.com/pohlai88/AFENDA/tree/main/.agents/skills/pg-sqill
Command: npx skills add https://github.com/pohlai88/AFENDA --skill pg-sqill

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill simplifies interacting with PostgreSQL databases, allowing users to easily query data and understand the database schema without needing direct SQL client access.

Core Features & Use Cases

  • Execute SQL Queries: Run custom SQL queries against the database.
  • Explore Schema: View the structure of tables within the database.
  • Use Case: Quickly check the number of users in the account table by running a query like SELECT COUNT(*) FROM public.account;.

Quick Start

Use the pg-sqill skill to query the database with the command SELECT * FROM public.account LIMIT 5.

Frequently Asked Questions about pg-sqill

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

FAQPage Schema
How do I query a PostgreSQL database without installing a SQL client?▼

You can query a PostgreSQL database by running custom SQL queries directly through this Skill, which requires a DATABASE_URL environment variable and uses psql for execution.

What is the best way to explore PostgreSQL schemas during development?▼

Exploring PostgreSQL schemas is done by using this Skill to view the structure of tables within the database, utilizing psql for schema introspection without direct SQL client access.

Do I need a specific environment variable to run SQL queries against my database?▼

Yes, executing SQL queries requires a DATABASE_URL environment variable to be set, allowing the Skill to connect to the PostgreSQL database and run operations.

How do I count rows in a specific PostgreSQL table like public.account?▼

You can count rows in a PostgreSQL table by running a custom SQL query like SELECT COUNT(*) FROM public.account; through this Skill's streamlined interface.

Can I use psql for database introspection without direct command line access?▼

Yes, this Skill utilizes psql for schema introspection and query execution, providing a streamlined interface to interact with your PostgreSQL database without direct command line access.

Related Skills

Explore More Software Engineering Skills→
qhkmqhkm
4

postgres

Automate PostgreSQL queries, schema changes, backups, and diagnostics via psql tools.

Community
Advanced
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced
ano4lano4l

sql-database-assistant

Automate SQL queries, migrations, and ORM integration across multiple databases.

Community
Advanced