postgresql

Name: postgresql
Availability: InStock
Author: zphwd

Document PostgreSQL SQL queries, database design, administration, and performance tuning.

Updated Feb 23, 2026

Search Tags:#database #postgresql #queries #sql #performance tuning #administration

Ready to run

npx skills add https://github.com/zphwd/bianchengbaodian --skill postgresql-zphwd

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/zphwd/bianchengbaodian/tree/main/skills/postgresql
Command: npx skills add https://github.com/zphwd/bianchengbaodian --skill postgresql-zphwd

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive documentation and guidance for working with PostgreSQL databases, SQL queries, database design, administration, and performance tuning.

Core Features & Use Cases

SQL Querying: Write and optimize complex SQL queries.
Database Design: Understand and implement effective database schemas.
Administration & Tuning: Manage PostgreSQL instances and improve performance.
Use Case: You need to write an efficient SQL query to join two tables and filter the results based on a specific date range. This Skill can provide the syntax and best practices for constructing that query.

Quick Start

Use the postgresql skill to get documentation on how to connect to a PostgreSQL database using libpq.

Frequently Asked Questions about postgresql

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

FAQPage Schema

How do I write an efficient PostgreSQL query to join tables and filter by a date range?▼

To write an efficient PostgreSQL query, you need the correct SQL syntax for joining tables and filtering by date ranges. Comprehensive PostgreSQL documentation provides the syntax and best practices for constructing complex queries to ensure optimal database performance.

What's the best way to connect to a PostgreSQL database using libpq connection strings?▼

Connecting to a PostgreSQL database using libpq requires specific connection control functions and parameter keywords. Detailed documentation provides comprehensive information on connection string formats and parameters needed to establish and manage database connections.

How do I tune PostgreSQL database performance for slow SQL queries?▼

PostgreSQL performance tuning involves optimizing slow SQL queries and managing database instances. Documentation covers administration and tuning techniques to help you understand performance bottlenecks and apply best practices to improve query execution speed.

Does this PostgreSQL documentation cover database design and schema implementation?▼

Yes, this PostgreSQL documentation covers database design comprehensively. It provides guidance on understanding and implementing effective database schemas, helping you structure your data models correctly within the PostgreSQL system.

What connection control functions and parameter keywords are available for PostgreSQL administration?▼

PostgreSQL administration utilizes specific connection control functions and parameter keywords for managing database systems. The included documentation details these functions and formats to facilitate working with PostgreSQL instances and controlling connections.