beh74/pgassistant-community
A PostgreSQL assistant for developers Understand, optimize, and improve your PostgreSQL database with ease.
This tool helps backend developers, DBAs, and DevOps engineers understand and improve the performance of their PostgreSQL databases. It takes database schema definitions, configuration, and actual query execution plans as input. It then identifies performance bottlenecks, suggests optimal indexes, recommends query rewrites, and proposes parameter tuning, helping users make informed decisions to speed up slow queries and optimize database structure.
Use this if you need to diagnose slow PostgreSQL queries or structural issues in your database and want actionable recommendations to fix them, especially if you lack a dedicated DBA.
Not ideal if you're looking for a simple metrics dashboard or a tool that blindly applies changes without human review.
Stars
26
Forks
3
Language
CSS
License
—
Category
Last pushed
Mar 02, 2026
Commits (30d)
0
Get this data via API
curl "https://pt-edge.onrender.com/api/v1/quality/llm-tools/beh74/pgassistant-community"
Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.
Higher-rated alternatives
CodePhiliaX/Chat2DB
AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle,...
julien040/anyquery
Query anything (GitHub, Notion, +40 more) with SQL and let LLMs (ChatGPT, Claude) connect to using MCP
DEEP-PolyU/Awesome-LLM-based-Text2SQL
[TKDE2025] Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL | A curated...
TuGraph-family/Awesome-Text2GQL
Fine-Tuning Dataset Auto-Generation for Graph Query Languages.
eosphoros-ai/Awesome-Text2SQL
Curated tutorials and resources for Large Language Models, Text2SQL, Text2DSL、Text2API、Text2Vis...