Cursor (AI)  ←── MCP (stdio) ──→  server.py  ←── SQL ──→  MySQL (lexiguard)

CREATE DATABASE IF NOT EXISTS lexiguard;
USE lexiguard;

CREATE TABLE IF NOT EXISTS departments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    location VARCHAR(100)
);

CREATE TABLE IF NOT EXISTS employees (
    id INT AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE,
    department_id INT,
    hire_date DATE,
    salary DECIMAL(10, 2),
    FOREIGN KEY (department_id) REFERENCES departments(id)
);

INSERT INTO departments (name, location) VALUES
('Engineering', 'London'),
('HR', 'Manchester'),
('Finance', 'Birmingham');

INSERT INTO employees (first_name, last_name, email, department_id, hire_date, salary) VALUES
('Alice', 'Smith', 'alice.smith@lexiguard.com', 1, '2022-03-15', 65000.00),
('Bob', 'Jones', 'bob.jones@lexiguard.com', 1, '2021-07-01', 72000.00),
('Carol', 'Brown', 'carol.brown@lexiguard.com', 2, '2020-11-20', 48000.00),
('David', 'Taylor', 'david.taylor@lexiguard.com', 3, '2023-01-10', 55000.00);

cd db-mcp-server
python -m venv .venv
.\.venv\Scripts\pip install -r requirements.txt

cd db-mcp-server
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

cp .env.example .env

"command": "${workspaceFolder}/.venv/bin/python"

"command": "${workspaceFolder}/.venv/Scripts/python.exe"

db-mcp-server/
├── .cursor/
│   └── mcp.json          # Cursor MCP launch config
├── server.py             # MCP server (FastMCP + MySQL)
├── requirements.txt
├── .env.example          # Copy to .env locally
├── .gitignore
├── README.md             # This file (demo / setup)
└── MCP-HOW-IT-WORKS.md   # Short technical notes on MCP