NextJS
React
TypeScript
ShadcnUIUnified platform for analyzing and optimizing PostgreSQL cluster settings and SQL queries.
Built at the VTB "MORE.Tech" hackathon and won the "PostgreSQL" case
Service features
- Real-time database metrics analysis with continuous monitoring
- AI recommendations for detecting issues beyond algorithmic analysis
- Autovacuum, cache, temp files, and index analysis
- Two-level query analysis: SQL parsing + EXPLAIN with JSON processing
- Query history analysis from pg_stat_statements
My role in the project
- Full frontend development on Next.js
- Server deployment: Docker containers and database
- Half of the pitch presentation
- Backend and AI metrics analysis – teammates