SQL static analyzer for performance, security, compliance and cost. 272 rules. Completely offline. Works in CI pipelines.

🩺⚡ Runtime Doctrine ORM analysis integrated into Symfony Web Profiler. Detect N+1 queries, security 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 security of the site and improve the performance of the site by disabling completely unnecessary hooks and also optimizing SQL queries

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

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

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

Advanced spatial-temporal data analysis and indexing optimization on 1.7M+ taxi trajectories using PostgreSQL and PostGIS.

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.

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

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.

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

Bachelor thesis on query optimization for Business Intelligence systems. Analysis of ETL, physical design (indexing, partitioning, compression, caching), and materialized views on SQL Server and Azure Synapse. Includes SQL scripts and TPC-DS evaluations.

A hands-on MongoDB practice repository focused on real-world database operations, including CRUD workflows, query optimization, aggregation pipelines, indexing, and core administrative tasks. Structured into organized scripts, it supports progressive learning and reinforces practical NoSQL database design principles.

A Developer’s Journey to Choosing the Right ID Solution

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.

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.