Document PostgreSQL SQL queries, database design, administration, and performance tuning.
npx skills add https://github.com/zphwd/bianchengbaodian --skill postgresql-zphwd
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
This Skill provides comprehensive documentation and guidance for working with PostgreSQL databases, SQL queries, database design, administration, and performance tuning.
Use the postgresql skill to get documentation on how to connect to a PostgreSQL database using libpq.
High-intent search queries and answers about installing and using this skill.
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.
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.
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.
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.
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.
shelbeelyConfigure Prisma ORM with database providers and driver adapters.
dathereAutomate CSV data wrangling workflows with qsv for indexing, profiling, transforming, and exporting.
asgarovfDesign database schemas, write SQL queries, and create migrations.
AreteDriverDesign relational database schemas and generate migration scripts for PostgreSQL, MySQL, and SQLite.
