Manage PostgreSQL databases with SQL queries, backups, and performance tuning.
npx skills add https://github.com/tanaer/lobster-university-v2 --skill postgres-db
Please help me install this Agent Skill. Skill: postgres-db Source: https://github.com/tanaer/lobster-university-v2/tree/main/skills/courses/postgres-db Command: npx skills add https://github.com/tanaer/lobster-university-v2 --skill postgres-db
This Skill empowers users to efficiently manage and interact with PostgreSQL databases, solving the problem of complex database operations becoming a bottleneck.
Connect to the PostgreSQL database using the provided credentials and execute the SQL query to list all tables in the public schema.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries, this Skill analyzes query execution plans to identify performance bottlenecks. It evaluates SQL statements to pinpoint inefficiencies and provides tuning recommendations for improved database responsiveness.
The best way to back up a PostgreSQL database is using tools like pg_dump for full or partial backups. This Skill also manages schema exports, allowing you to extract and save table structures directly from your database.
You can execute SQL queries by running SELECT, INSERT, UPDATE, and DELETE statements. This Skill handles SQL query execution and manages table structures, enabling seamless interaction with your PostgreSQL database data.
Yes, you can monitor PostgreSQL database activity and resource usage. This Skill checks database performance metrics to track active sessions and resource consumption, helping you maintain optimal database health.
No specific external dependencies are required to use this PostgreSQL management Skill. It interfaces directly with your database environment using standard tools like psql and pg_dump to execute queries and perform backups.
pgplexValidate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.
EpiphyticConvert laboratory instrument output files into Allotrope Simple Model JSON and CSV formats.
stacksjsExecute and manage shell commands in Stacks projects via @stacksjs/shell.
i9placesolutionsManage PostgreSQL schema migrations, query optimization, and real-time data handling.
