Document PostgreSQL SQL syntax, database design, and performance tuning.
npx skills add https://github.com/Aniket-a14/AI_friend --skill postgresql-aniket-a14
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/Aniket-a14/AI_friend/tree/main/.gemini/skills/postgresql Command: npx skills add https://github.com/Aniket-a14/AI_friend --skill postgresql-aniket-a14
This Skill provides comprehensive documentation and guidance for working with PostgreSQL databases, covering everything from basic SQL queries to advanced administration and performance tuning.
Use the postgresql skill to find documentation on how to connect to a PostgreSQL database.
High-intent search queries and answers about installing and using this skill.
PostgreSQL queries use joins to combine multiple tables and aggregate functions to calculate values across grouped rows. Correct syntax and best practices ensure efficient data retrieval and manipulation.
PostgreSQL database design relies on defining appropriate data types, applying normalization, and using table inheritance to structure hierarchical data. These principles ensure data integrity and efficient query performance across related tables.
PostgreSQL connection management uses connection strings with specific parameter keywords to establish database sessions. Configuring these parameters correctly controls authentication, network routing, and runtime behavior for secure database development.
PostgreSQL performance tuning involves optimizing SQL queries, configuring connection management, and applying strategic indexing. Following documented tuning strategies reduces latency and improves overall database administration efficiency.
Yes, the PostgreSQL documentation covers installation guides, connection management functions, and administration tasks. It provides the necessary steps to set up the database environment and manage ongoing operations effectively.
You need specific PostgreSQL data types when defining table schemas to ensure data integrity and optimize storage. Selecting appropriate types during database design directly impacts query accuracy and performance tuning outcomes.
zphwdDocument PostgreSQL SQL queries, database design, administration, and performance tuning.
augustsclOptimize Postgres queries and schemas with SQL examples and EXPLAIN guidance.
vitoropereiraOptimize PostgreSQL performance with indexing, schema, and connection best practices.
htlin222Develop and optimize SQL queries, design schemas, and advise on indexing strategies.
