{"repo":"beh74/pgassistant-community","free":true,"listed":false,"github":"https://github.com/beh74/pgassistant-community","clone":"git clone https://github.com/beh74/pgassistant-community.git","description":"A PostgreSQL assistant for developers Understand, optimize, and improve your PostgreSQL database with ease.","language":"JavaScript","stars":41,"topics":["design","llm","performance","postgresql"],"license":null,"category":"databases-storage","readme_excerpt":"pgAssistant Analyze one PostgreSQL database. Prioritize a fleet of thousands. Turn SQL, schema, workload, and fleet diagnostics into clear explanations, actionable recommendations, and an implementation plan. ⭐ Star pgAssistant on GitHub if it helps you improve your PostgreSQL databases. --- What is pgAssistant? pgAssistant is an open-source PostgreSQL analysis tool for developers, DBAs, and operations teams. It combines database introspection, workload analysis, specialized advisors, and implementation planning in a single web interface. It does more than display metrics: pgAssistant explains detected issues, proposes concrete actions, identifies the responsible team, and consolidates related recommendations into an ordered plan. AI assistance is optional. The core advisors remain deterministic and can be used without an LLM . Highlights - Multi-database support — connect to a PostgreSQL instance, list its databases, and select the database to analyze. - Global Advisor — deterministic database-wide checks ranked by priority, confidence, impact, and effort. - Executive Plan — combines Global, Index, Parameter, and Autovacuum recommendations into ordered work packages assigned to DEV, OPS, or DEV/OPS. - PDF reporting — generate a styled Executive Plan report filtered for DEV and/or OPS audiences, including a table of contents, maintenance requirements, sources, and SQL commands. - Query ranking — prioritize the workload using execution frequency and total database impact. - In","default_branch":null,"files":null,"tree":[],"storefront":"/r/beh74","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/beh74/pgassistant-community/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}