Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@lolosqltools validate table name 'CustomerOrders'"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
██╗ ██████╗ ██╗ ██████╗ ███████╗ ██████╗ ██╗ ████████╗ ██████╗ ██████╗ ██╗ ███████╗
██║ ██╔═══██╗██║ ██╔═══██╗██╔════╝██╔═══██╗██║ ╚══██╔══╝██╔═══██╗██╔═══██╗██║ ██╔════╝
██║ ██║ ██║██║ ██║ ██║███████╗██║ ██║██║ ██║ ██║ ██║██║ ██║██║ ███████╗
██║ ██║ ██║██║ ██║ ██║╚════██║██║▄▄ ██║██║ ██║ ██║ ██║██║ ██║██║ ╚════██║
███████╗╚██████╔╝███████╗╚██████╔╝███████║╚██████╔╝███████╗ ██║ ╚██████╔╝╚██████╔╝███████╗███████║
╚══════╝ ╚═════╝ ╚══════╝ ╚═════╝ ╚══════╝ ╚══▀▀═╝ ╚══════╝ ╚═╝ ╚═════╝ ╚═════╝ ╚══════╝╚══════╝MCP server that validates, formats, and generates SQL objects following BSG Institute standardization rules — integrated with Claude Code.
Tool | Description |
| Validates names for tables, views, SPs, functions, triggers, fields, and constraints |
| Full structural validation with compliance score (0–100) |
| Detects anti-patterns: missing TRY/CATCH, SELECT *, implicit cursors, etc. |
| Verifies mandatory audit fields (Estado, UsuarioCreacion, FechaCreacion, etc.) |
| Generates a complete BSG-compliant SQL template for any object type |
| Applies BSG formatting: keyword casing, leading-comma columns, clause indentation |
| Generates PascalCase-based table aliases with conflict detection |
| Generates a formatted production deployment request email |
| Generates a formatted database access request email |
| Returns BSG standardization rules filtered by object type and/or topic |
Related MCP server: MySQL MCP Server
Node.js 18 or higher
Claude Code (CLI)
Clone or download this repository
Run the installer:
.\install.ps1Custom install path:
.\install.ps1 -InstallPath "D:\tools\lolosqltools"Restart Claude Code
npm install
npm run buildThen register the MCP in ~/.claude/.mcp.json:
{
"mcpServers": {
"lolosqltools": {
"command": "node",
"args": ["/absolute/path/to/dist/index.js"]
}
}
}Restart Claude Code.
Add this block to your ~/.claude/CLAUDE.md to make Claude use LOLOSQLTOOLS automatically:
## LOLOSQLTOOLS MCP instructions for CLAUDE.md
The `lolosqltools` MCP is ALWAYS available. For any SQL object (table, view, SP, function, trigger), you MUST use it:
| Situation | Tool |
|---|---|
| Create a new SQL object | `generate_template` first, then deliver to user |
| Validate an object name | `validate_object_name` |
| Review an existing SQL block | `validate_sql_object` + `check_performance_patterns` |
| Format SQL | `format_sql` |
| Suggest a table alias | `suggest_alias` |
| Verify audit fields | `check_audit_fields` |
| Generate production deployment email | `generate_production_request` |
| Generate access request | `generate_access_request` |
| User asks about a BSG rule | `get_rules` |
**Critical rule**: NEVER generate SQL manually without consulting this MCP first.npm run dev # Run with tsx (no build needed)
npm run build # Compile TypeScript → dist/
npm start # Run compiled outputMIT
This server cannot be installed
Unclaimed servers have limited discoverability.
If you are the server author, to access and configure the admin panel.
Deterministic validation for AI-generated artifacts: JSON Schema, OpenAPI response, SQL syntax.
Live SEO workflow tools for Claude Code, Codex, and AI agents.
Validates ICD-10-CM against the real FY2026 catalog (NCHS/CDC) and CPT by structure/category.
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/lzaafe-alt/MCPLOLOSQLTOOLS'
If you have feedback or need assistance with the MCP directory API, please join our Discord server