postgres-db

Manage PostgreSQL databases with SQL queries, backups, and performance tuning.

Updated Aug 23, 2026

Search Tags:#postgresql #performance tuning #postgres #database backup #sql query #schema export #database monitoring

Ready to run

npx skills add https://github.com/tanaer/lobster-university-v2 --skill postgres-db

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to efficiently manage and interact with PostgreSQL databases, solving the problem of complex database operations becoming a bottleneck.

Core Features & Use Cases

SQL Query Execution: Run SELECT, INSERT, UPDATE, DELETE statements.
Schema Management: Export table structures and database schemas.
Backup and Restore: Perform full or partial database backups.
Performance Tuning: Analyze query execution plans and identify slow queries.
Monitoring: Check database activity and resource usage.

Quick Start

Connect to the PostgreSQL database using the provided credentials and execute the SQL query to list all tables in the public schema.

Frequently Asked Questions about postgres-db

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

FAQPage Schema

How do I optimize slow PostgreSQL queries and analyze execution plans?▼

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.

What is the best way to back up a PostgreSQL database and export table schemas?▼

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.

How do I execute SQL queries and manage table structures in PostgreSQL?▼

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.

Can I monitor PostgreSQL database activity and resource usage metrics?▼

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.

Does this PostgreSQL management Skill require any specific database connectors or dependencies?▼

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.