Provide PostgreSQL documentation for connections, SQL optimization, and installation.
npx skills add https://github.com/yongc2025/NovelFactory --skill postgresql-yongc2025
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/yongc2025/NovelFactory/tree/main/.skills/postgresql Command: npx skills add https://github.com/yongc2025/NovelFactory --skill postgresql-yongc2025
This skill addresses the complexity of managing PostgreSQL databases, providing instant access to documentation for connection handling, SQL query optimization, and database administration.
Ask the postgresql skill to explain how to establish a non-blocking connection to a database server using PQconnectStart.
High-intent search queries and answers about installing and using this skill.
To establish a non-blocking PostgreSQL connection with libpq, use the PQconnectStart function to initiate the connection sequence asynchronously. This allows your application to continue executing other tasks while waiting for the database server connection to complete.
Optimizing PostgreSQL query performance involves applying best practices for database indexing, aggregate functions, and schema design. Proper index construction ensures the query planner can efficiently retrieve data without scanning entire tables.
PostgreSQL provides operational guidance for monitoring server status and executing routine database administration tasks. This functionality ensures reliable database interaction and helps maintain system health across different operational environments.
Handling PostgreSQL installation requires following platform-specific instructions to correctly configure the database environment. This setup process ensures the database system is properly installed and ready for cross-platform deployment and connection management.
You need specific connection string parameters for secure PostgreSQL database interactions when configuring authenticated access via libpq. Proper connection handling guarantees that data transmission between the client and server remains protected and efficient.
FabianrzsConfigure Prisma across PostgreSQL, MySQL, SQLite, MongoDB, and SQL Server.
nahisahoSearch HCA Data Portal projects and export CELLxGENE Census subsets for Scanpy analysis.
2025EmmaProvide PostgreSQL development and administration guidance for SQL, schemas, and performance tuning.
jikimeManage and optimize PostgreSQL, MongoDB, Redis, and Oracle database systems.
