📚 A collection of work related to Database Optimization.
-
Updated
Feb 8, 2022
#
database-optimization
Here are 29 public repositories matching this topic...
Language: All
Filter by language
Sort: Most stars
Sort options
This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.
ecommerce query sql database view dbms indexing plsql trigger subquery database-design denormalization stored-procedure clustring databasemanagementsystem database-management-system database-optimization subqueries-and-joins
-
Updated
Oct 30, 2024 - PLpgSQL
Oscillink — Self‐Optimizing Coherent Memory for Embedding Workflows
database-optimization-plugins rag database-optimization physics-informed-neural-networks ai-memory hallucination-mitigation
-
Updated
Oct 17, 2025 - Python
SQLite Enhancer is a Magisk module designed to optimize the performance of SQLite databases on your Android device.
-
Updated
Aug 12, 2025
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
php wordpress wordpress-plugin security performance optimization wordpress-muplugin wordpress-security query-optimization composer-package wordpress-performance database-optimization speed-optimization
-
Updated
Oct 23, 2025 - PHP
🛍️ Enterprise-scale e-commerce platform with microservices architecture. Handles 2K+ TPS with sub-100ms latency using Redis caching, optimized databases, and Elasticsearch search.
react redis elasticsearch mongodb postgresql e-commerce microservices-architecture enterprise-grade performance-optimization nestjs database-optimization
-
Updated
Jul 25, 2025 - TypeScript
🔄 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 database-management query-optimizer database-monitoring database-security database-optimization devops-automation python-postgresql chatgpt-tools database-admin ai-integration database-performance mcp-server claude-integration ai-database-tools sql-automation database-diagnostics postgres-tools database-health-check postgres-monitoring
-
Updated
Sep 21, 2025 - Python
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.
mysql python open-source ai mcp database-management diagnostics performance-analysis sql-queries claude database-security database-optimization ai-tools claude-desktop model-context-protocol mcp-server claude-mcp mysql-diagnostics
-
Updated
Oct 17, 2025 - Python
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.
scalability postgresql indexing asp-net-core connection-pooling ef-core large-dataset cursor-pagination database-optimization
-
Updated
Jul 8, 2025 - C#
-
Updated
Jun 28, 2025
A Developer’s Journey to Choosing the Right ID Solution
-
Updated
Nov 10, 2024 - Java
Performance optimization and scaling strategies for modern software systems. Auto-scaling, caching, database optimization.
caching enterprise documentation performance framework cdn optimization best-practices scalability performance-tuning software-development high-availability auto-scaling scaling performance-monitoring production-ready guides load-balancing database-optimization infrastructure-scaling
-
Updated
Jul 7, 2025
Un proyecto de diseño, modelado y optimización de una base de datos Oracle SQL para servir una Historia de Condiciones Climatológicas y Ambientales en el Valle de Aburrá
-
Updated
Aug 5, 2022
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
sql nosql data-generation nosql-database mssqlserver database-optimization navica microsoft-sql-server-studio
-
Updated
Jan 27, 2020
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.
energy sql database transportation hackerrank healthcare banking data-analysis manufacturing data-management query-optimization inventory-management sql-queries advanced-sql database-optimization operational-analytics industry-specific-sql
-
Updated
Jan 2, 2025
Курсовая работа по проектированию БД с GUI на PyQt6. Комплексная информационная система для управления каталогом мобильных устройств. Реализована нормализованная PostgreSQL база данных (3НФ), Python/PyQt6 интерфейс с полным CRUD-функционалом и система анализа производительности с 95% оптимизацией запросов.
python sql postgresql data-visualization gui-application desktop-application data-analysis coursework crud-application relational-database mobile-devices database-design database-optimization moscow-polytech pyqt6
-
Updated
Jun 30, 2025 - Python
In this repository, you will find a collection of basic to advanced T-SQL queries for Microsoft SQL Server, curated for practice and learning purposes
-
Updated
Jul 22, 2025 - TSQL
🎯 Database optimization and sales performance analysis for a fine wine company seeking to improve their data management practices and data maturity level - use of Python and JupyterLab (Business insights, Data collection, Cleaning, EDA, and Data Visualization)
-
Updated
Nov 3, 2023 - Jupyter Notebook
Improve this page
Add a description, image, and links to the database-optimization topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the database-optimization topic, visit your repo's landing page and select "manage topics."