A Comprehensive Analysis of MySQL Connection Operations: Deep Understanding from Inner Join to Outer Join

To intuitively understand join operations, we first build a simple example database that stores grocery items and their corresponding categories. The category information is stored in the categories ...

MySQL Index Revealed: A Deep Dive into Clustered and Non-Clustered Indexes

In the process of using MySQL databases, indexes are an important mechanism that cannot be ignored, significantly enhancing query performance. This article will delve into two fundamental types of ...
GitHub

A comprehensive SQL project using the classic Employees sample database. Includes database dump and practice queries covering SQL basics, joins, subqueries, window functions ...

Since the complete database dump is larger than GitHub’s 25MB file size limit, I have uploaded it to Google Drive. 👉 Download Full Database Dump (https://drive ...
GitHub

benborla/mcp-server-mysql

A Model Context Protocol server that provides access to MySQL databases through SSH tunnels. This server enables Claude and other LLMs to inspect database schemas and execute SQL queries securely.