{"skill":{"slug":"postgres-db","displayName":"PostgreSQL Database","summary":"PostgreSQL 数据库操作技能。用于执行SQL查询、表管理、备份恢复、性能监控等数据库操作。触发条件：用户提到 PostgreSQL、postgres、数据库查询、SQL查询、表结构、数据库备份等。","description":"---\nname: postgres-db\ndescription: PostgreSQL 数据库操作技能。用于执行SQL查询、表管理、备份恢复、性能监控等数据库操作。触发条件：用户提到 PostgreSQL、postgres、数据库查询、SQL查询、表结构、数据库备份等。\n---\n\n# PostgreSQL Database Skill\n\n## Overview\n\nThis skill provides comprehensive PostgreSQL database operations including query execution, schema management, backup/restore, and performance monitoring.\n\n## Capabilities\n\n### 1. SQL Query Execution (`scripts/query.py`)\nExecute SQL queries against PostgreSQL databases with support for:\n- SELECT queries with result formatting\n- INSERT/UPDATE/DELETE operations\n- Transaction support\n- Query result export (JSON, CSV)\n\n### 2. Schema Export (`scripts/schema_export.py`)\nExport database schema information:\n- Table structures (columns, types, constraints)\n- Indexes and foreign keys\n- Views and triggers\n- Export to JSON/Markdown format\n\n### 3. Database Backup (`scripts/backup.py`)\nDatabase backup and restore operations:\n- Full database backup using pg_dump\n- Table-specific backup\n- Point-in-time recovery support\n- Backup rotation management\n\n### 4. Performance Monitoring\nMonitor database performance:\n- Query execution plans (EXPLAIN ANALYZE)\n- Index usage statistics\n- Table size and row counts\n- Connection pool status\n\n## Usage\n\n### Query Database\n```bash\npython scripts/query.py --dbname mydb --query \"SELECT * FROM users LIMIT 10\"\n```\n\n### Export Schema\n```bash\npython scripts/schema_export.py --dbname mydb --output schema.json\n```\n\n### Backup Database\n```bash\npython scripts/backup.py --dbname mydb --backup-dir /backups\n```\n\n## Requirements\n\n- PostgreSQL client tools (psql, pg_dump)\n- Python 3.7+\n- psycopg2 or asyncpg library\n\n## Configuration\n\nSet environment variables:\n- `PGHOST` - Database host\n- `PGPORT` - Database port (default: 5432)\n- `PGDATABASE` - Database name\n- `PGUSER` - Database user\n- `PGPASSWORD` - Database password\n","topics":["Database","PostgreSQL","备份恢复","数据库"],"tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":1741,"installsAllTime":65,"installsCurrent":2,"stars":1,"versions":1},"createdAt":1772265146791,"updatedAt":1779077422708},"latestVersion":{"version":"1.0.0","createdAt":1772265146791,"changelog":"Initial release: PostgreSQL database operations including query execution, schema export, and backup functionality","license":null},"metadata":null,"owner":{"handle":"limoxt","userId":"s173j0m2t7jp4v1d9ysjxtks2s885zxf","displayName":"limoxt","image":"https://avatars.githubusercontent.com/u/102217440?v=4"},"moderation":{"isSuspicious":false,"isMalwareBlocked":false,"verdict":"clean","reasonCodes":["review.llm_review"],"summary":"Review: review.llm_review","engineVersion":"v2.4.24","updatedAt":1779967042292}}