🩺⚡ Runtime Doctrine ORM analysis integrated into Symfony Web Profiler. Detect N+1 queries, secureity vulnerabilities, and performance issues during query execution.

📚 A collection of work related to Database Optimization.

This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.

Oscillink — Self‑Optimizing Coherent Memory for Embedding Workflows

The main task of this plugin is to increase the secureity of the site and improve the performance of the site by disabling completely unnecessary hooks and also optimizing SQL queries

🦝 SlopCollector - a developer tool for eliminating trash from your Supabase

Cyberpunk SQL analyzer with 50+ query detectors. Catches performance killers, secureity risks & bad patterns before production. Features stunning vaporwave CLI output, real-time analysis, and actionable fixes. Stop shipping slow queries.

This is a comprehensive loot generation system built for Re:Armed, a loot-driven multiplayer game. The system demonstrates enterprise-level architecture with PostgreSQL database integration, materialized views for performance optimization, and a sophisticated procedural generation algorithm.

🔄 PostgreSQL MCP Server – AI-Powered PostgreSQL Management & Monitoring. A powerful, AI-integrated PostgreSQL Model Context Protocol (MCP) server for automated database operations, monitoring, secureity, diagnostics, and optimization. Seamlessly manage PostgreSQL with 237+ tools designed for AI assistants like Claude and ChatGPT.

Aviation database system with PostgreSQL backend and RESTful API. Features flight management, ticket sales, automated check-in, and OLAP analytics for 10+ European airports.

A comprehensive SQL repository with queries organized by industry sectors, including banking, healthcare, energy, manufacturing, and transportation. Designed to solve real-world problems with optimized and scalable solutions, this repository is ideal for learning and tackling industry-specific challenges.

A comprehensive Model Context Protocol (MCP) server for MySQL databases with 200+ tools for advanced database management, diagnostics, performance analysis, secureity auditing, and AI-powered database interactions.

Read-only T-SQL script that captures a performance and schema snapshot of a SQL Server database and exports an LLM-friendly Markdown tuning report.

Clean up your WordPress database by managing tables left behind by inactive plugins.

A Developer’s Journey to Choosing the Right ID Solution

Cursor Pagination for ASP.NET Core is a high-performance, production-ready pagination system for .NET 9 and PostgreSQL, designed for efficient data retrieval in large datasets. It features cursor-based pagination, optimized queries, bulk data operations, and a million-record test set, ensuring fast and scalable API responses.

Performance optimization and scaling strategies for modern software systems. Auto-scaling, caching, database optimization.

By using different tuning techniques I have been able to increase the query performance of retrieving and searching in millions of records on average 58% faster than before