database-optimization

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.

Oscillink — Self‑Optimizing Coherent Memory for Embedding Workflows

🔄 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.

PostgreSQL 16 + IMDb: SKIP LOCKED message queue ingestion, JSONB/TOAST, and real before/after indexing benchmarks

Home Assistant integration: drop-in utility_meter replacement that stores one consolidated point per cycle in Long-Term Statistics instead of thousands of rows.

Claude Code skill: find & fix DB/API performance bottlenecks (N+1, indexes, slow routes) and prove every fix with before/after benchmarks. Stack-agnostic.

Engineering case study: taking a query on 11.2M NYC taxi trip rows in MySQL from a full table scan to a covering index + partition-pruned scan, proven with EXPLAIN ANALYZE

Evidence-driven SQL query profiling and index optimization engine with workload analysis, benchmark validation, cost-benefit evaluation, and production decision support.

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

ТОП-10 компаний по повышению производительности высоконагруженных сайтов и веб-сервисов в России, 2026. Метод Лаб, ITSumma, Перфоманс Лаб и другие участники | Исследование IndexResearch

TechCompass is a Streamlit-powered application designed to guide users through the intricate world of technology, offering resources and guides on data engineering, programming, and automation techniques. It features an interactive UI for exploring and downloading comprehensive guides.

Database performance engineering lab demonstrating 148x query optimization through advanced indexing strategies and ACID-compliant transaction patterns. Features production-ready implementations spanning both SQL and NoSQL paradigms with measured performance analytics. A practical showcase of database engineering principles.

A full-stack Personal Expense Tracker built with Python Flask and MySQL, designed to help users manage income, expenses, budgets, and financial reports.

Django Learning Journey: A structured guide to learning Django step by step. This resource includes detailed notes, examples, and practical exercises covering models, ORM, database interactions, and core Django concepts. It is designed for hands-on learning and to serve as a personal reference

PostgreSQL analytics system for content engagement: materialized views and composite indexes behind a FastAPI layer.