skills.rest
AstorYH
AstorYHCOMMUNITY
Explore all skills by this author →
GitHub

postgresql-query-runner

Execute PostgreSQL SQL queries against specified database connections.

15|8|Updated Feb 9, 2026
Search Tags:#database#postgresql#data access#sql#query#data retrieval
One-click install
npx skills add https://github.com/AstorYH/PASB --skill postgresql-query-runner
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-query-runner
Source: https://github.com/AstorYH/PASB/tree/main/nanobot/skills/postgresql-query-runner
Command: npx skills add https://github.com/AstorYH/PASB --skill postgresql-query-runner

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill allows users to execute SQL queries against a PostgreSQL database and retrieve the results, automating data retrieval and analysis tasks.

Core Features & Use Cases

  • Execute SQL Queries: Run any valid PostgreSQL query.
  • Data Retrieval: Fetch query results in a structured format (list of dictionaries).
  • Flexible Connection: Supports both default environment configurations and explicit connection strings.
  • Use Case: Retrieve all customer records from the 'customers' table where the 'signup_date' is within the last month.

Quick Start

Execute the SQL query 'SELECT COUNT(*) FROM orders;' against the PostgreSQL database.

Frequently Asked Questions about postgresql-query-runner

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

FAQPage Schema
How do I execute SQL queries against a PostgreSQL database?▼

To execute SQL queries against a PostgreSQL database, you provide valid SQL syntax and an accessible connection string. The skill runs your query and returns the retrieved data in a structured list of dictionaries.

What is the best way to retrieve data from a PostgreSQL database for reporting?▼

Retrieving data from a PostgreSQL database for reporting requires executing valid SQL queries. This skill fetches query results in a structured format, automating data retrieval and analysis tasks for your reports.

Do I need a specific connection string to run PostgreSQL queries?▼

You do not always need a specific connection string to run PostgreSQL queries. The skill supports flexible connections, allowing you to use default environment configurations or provide an explicit connection string.

Can I use arbitrary SQL syntax for data retrieval with this PostgreSQL tool?▼

You can use arbitrary SQL syntax for data retrieval with this PostgreSQL tool. It requires valid PostgreSQL syntax to successfully execute your queries and fetch the requested database records.

What format are PostgreSQL query results returned in?▼

PostgreSQL query results are returned in a structured format consisting of a list of dictionaries. This structure facilitates immediate data inspection and downstream analysis after executing your SQL statements.

Related Skills

Explore More Data & Analytics Skills→
Aniket-a14Aniket-a14
1

postgresql

Document PostgreSQL SQL syntax, database design, and performance tuning.

Community
Intermediate
bettyguobettyguo
8

extract-table-pagination

Extract HTML table rows into dictionaries and paginate via next controls.

Community
Intermediate
acefrost511acefrost511

data-analyst

Analyze SQL, spreadsheet, and warehouse data with cleaning and reporting workflows.

Community
Advanced
snoodleboot-iosnoodleboot-io
2

nosql-database-selection

Assess application requirements and recommend suitable NoSQL database types.

Official
Intermediate