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

Ready to run

npx skills add https://github.com/AstorYH/PASB --skill postgresql-query-runner

💬 Prompt for ChatGPT / Claude Chat▼

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.