📊 Analyze content engagement to uncover strategy opportunities with this production-grade PostgreSQL analytics platform.

📊 Optimize time-series data storage and analysis with TimescaleDB, enabling efficient queries and scalable performance for your applications.

📚 Master Django with this organized series featuring code, resources, and notes for building a complete e-commerce storefront.

🛠️ Simplify MySQL database management and enhance user experience with powerful tools and features tailored for efficient workflows.

Analyze and optimize complex spatial-temporal taxi trajectory data using PostgreSQL, PostGIS, and Python for efficient database querying and indexing.

🎯 Generate scalable, database-driven loot for multiplayer RPGs using a procedural system with PostgreSQL and C# integration.

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.

WordPress-плагин для оптимизации изображений, очистки базы данных и мониторинга здоровья сайта

A project to master database indexing strategies in PostgreSQL by creating and optimizing B-Tree, functional, multi-column, unique, and partial indexes to improve SQL query performance.

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.

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

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.

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.

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

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

Sistema de agentes inteligentes para analisis y optimizacion automatica de indices en PostgreSQL

This is a portfolio of SQL analytics, database design, and performance optimization projects, including real-world style reporting pipelines and Java-based database integration.