postgresql-bi-agent
CommunityTurn PostgreSQL data into actionable BI insights.
Authordigoal
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Automates PostgreSQL BI analysis to reveal metadata, data patterns, and actionable insights.
Core Features & Use Cases
- Metadata discovery and schema mapping to identify tables, keys, and relationships.
- Data sampling and pattern analysis to understand value distributions and data quality.
- SQL generation for business-relevant metrics and automated reporting.
- End-to-end BI pipeline: discovery, sampling, query execution, analysis, and reporting.
- Use Case: Connect to a read-only database and generate a comprehensive BI report covering revenue, customers, and product performance.
Quick Start
Run the full BI analysis with: python3 scripts/business_intelligence_agent.py --full-analysis Or run targeted analysis: python3 scripts/business_intelligence_agent.py --skill discover_database_metadata
Dependency Matrix
Required Modules
psycopg2pandasnumpyjinja2
Components
scriptsassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgresql-bi-agent Download link: https://github.com/digoal/postgres_skill/archive/main.zip#postgresql-bi-agent Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.