skills.rest
digoaldigoalCommunity·3 Agent Skills Included

postgres_skill

Automated PostgreSQL health checks and business data analysis

Runs comprehensive daily health checks on PostgreSQL and PolarDB instances, covering locks, bloat, replication, cache hit rates, and wraparound risks. Generates business intelligence reports by discovering database metadata, building revenue and customer SQL queries, and analyzing trends. Eliminates manual DBA inspections and spreadsheet reporting with structured Markdown reports and prioritized fix recommendations.
38|12
↗
npx skills add digoal/postgres_skill --all -g -y

All Skills in This Repository (3)

Pure Emerald Level Indicators
📦 In Repo
digoaldigoal

polardb-daily-check

Assess PolarDB for PostgreSQL health via polar_monitor and PostgreSQL queries.

Community
Advanced
📦 In Repo
digoaldigoal

postgresql-bi-agent

Automate PostgreSQL BI analysis from metadata discovery to reporting.

Community
Intermediate
📦 In Repo
digoaldigoal

postgres-daily-check

Analyze PostgreSQL instances and generate a daily health report.

Community
Advanced

Frequently Asked Questions

FAQPage Schema
How to install postgres_skill?▼

Run `npx skills add digoal/postgres_skill --all -g -y` in your terminal to install all three skills globally.

How to run a PostgreSQL daily health check?▼

Ask your agent to fully inspect the database with your connection details, and it runs dozens of checks on locks, bloat, cache hit rate, and replication, then returns a prioritized Markdown report.

Does it support PolarDB for PostgreSQL?▼

Yes. The polardb-daily-check skill adds PolarDB-specific monitoring for LogIndex replay lag, shared storage performance, HTAP/MPP workers, and node synchronization.

Can it analyze business data in PostgreSQL?▼

Yes. The postgresql-bi-agent skill discovers your table structure, generates revenue, customer, and product SQL queries, and produces a full business intelligence report.

Do I need DBA experience to use it?▼

No. You describe the inspection in plain language, and the agent runs the SQL checks and explains issues with concrete fix recommendations.

Related Repositories in Data & Analytics

View All in Data & Analytics→
PaddlePaddlePaddlePaddle
87.3k

PaddleOCR

Extract text, tables, and formulas from PDFs and images

Official📦 2 Skills
D4VinciD4Vinci
73.3k

Scrapling

Scrape any website and bypass anti-bot protection with AI

Community📦 1 Skills
mvanhornmvanhorn
60.8k

last30days-skill

Research any topic across Reddit, X, YouTube, and the web

Community📦 2 Skills