postgresql

Guide PostgreSQL developers through SQL, schema design, administration, and performance tuning.

Updated Apr 27, 2026
One-click install
npx skills add https://github.com/Bearflower/stockfiter --skill postgresql-bearflower
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/Bearflower/stockfiter/tree/main/skills/vibe-coding-cn-main/i18n/zh/skills/postgresql
Command: npx skills add https://github.com/Bearflower/stockfiter --skill postgresql-bearflower

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PostgreSQL documentation and practical guidance for SQL development, database design, administration, and performance tuning, helping users reduce trial-and-error and accelerate learning.

Core Features & Use Cases

  • Authoritative PostgreSQL guidance drawn from official docs, including SQL basics, advanced features, and admin tasks.
  • Use Case: design robust schemas, optimize queries, manage users/permissions, and tune server performance in development and production.

Quick Start

Run a simple PostgreSQL query against a sample database to observe results.

Frequently Asked Questions about postgresql

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

FAQPage Schema
How do I optimize PostgreSQL query performance in production?

To optimize PostgreSQL query performance, apply official documentation guidance on performance tuning, including query optimization, index design, and server configuration across development, testing, and production environments.

What is the best way to design robust PostgreSQL schemas?

The best way to design robust PostgreSQL schemas is to follow practical examples and usage patterns from official documentation, ensuring proper data modeling and structural integrity for your specific application requirements.

How do I manage users and permissions in PostgreSQL?

You manage PostgreSQL users and permissions by following practical administration examples and usage patterns drawn from official documentation, covering role assignment and access control across different environments.

Can I use official PostgreSQL documentation for both basic and advanced SQL features?

Yes, you can use official PostgreSQL documentation for both basic and advanced SQL features, as it provides authoritative guidance on SQL development, advanced querying, and administrative tasks.

Does PostgreSQL require performance tuning for development and testing environments?

PostgreSQL performance tuning is applicable across development, testing, and production environments, helping reduce trial-and-error and accelerate learning through practical examples and official documentation references.