Skip to main content
Glama
lzaafe-alt

lolosqltools

by lzaafe-alt
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Local
██╗      ██████╗ ██╗      ██████╗ ███████╗ ██████╗ ██╗     ████████╗ ██████╗  ██████╗ ██╗     ███████╗
██║     ██╔═══██╗██║     ██╔═══██╗██╔════╝██╔═══██╗██║     ╚══██╔══╝██╔═══██╗██╔═══██╗██║     ██╔════╝
██║     ██║   ██║██║     ██║   ██║███████╗██║   ██║██║        ██║   ██║   ██║██║   ██║██║     ███████╗
██║     ██║   ██║██║     ██║   ██║╚════██║██║▄▄ ██║██║        ██║   ██║   ██║██║   ██║██║     ╚════██║
███████╗╚██████╔╝███████╗╚██████╔╝███████║╚██████╔╝███████╗   ██║   ╚██████╔╝╚██████╔╝███████╗███████║
╚══════╝ ╚═════╝ ╚══════╝ ╚═════╝ ╚══════╝ ╚══▀▀═╝ ╚══════╝   ╚═╝    ╚═════╝  ╚═════╝ ╚══════╝╚══════╝

MCP server that validates, formats, and generates SQL objects following BSG Institute standardization rules — integrated with Claude Code.

Tools

Tool

Description

validate_object_name

Validates names for tables, views, SPs, functions, triggers, fields, and constraints

validate_sql_object

Full structural validation with compliance score (0–100)

check_performance_patterns

Detects anti-patterns: missing TRY/CATCH, SELECT *, implicit cursors, etc.

check_audit_fields

Verifies mandatory audit fields (Estado, UsuarioCreacion, FechaCreacion, etc.)

generate_template

Generates a complete BSG-compliant SQL template for any object type

format_sql

Applies BSG formatting: keyword casing, leading-comma columns, clause indentation

suggest_alias

Generates PascalCase-based table aliases with conflict detection

generate_production_request

Generates a formatted production deployment request email

generate_access_request

Generates a formatted database access request email

get_rules

Returns BSG standardization rules filtered by object type and/or topic

Related MCP server: claude-database-tools

Requirements

  • Node.js 18 or higher

  • Claude Code (CLI)

Installation

Windows (PowerShell)

  1. Clone or download this repository

  2. Run the installer:

.\install.ps1

Custom install path:

.\install.ps1 -InstallPath "D:\tools\lolosqltools"

  1. Restart Claude Code

Manual installation

npm install
npm run build

Then register the MCP in ~/.claude/.mcp.json:

{
  "mcpServers": {
    "lolosqltools": {
      "command": "node",
      "args": ["/absolute/path/to/dist/index.js"]
    }
  }
}

Restart Claude Code.

CLAUDE.md instructions

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.

Development

npm run dev    # Run with tsx (no build needed)
npm run build  # Compile TypeScript → dist/
npm start      # Run compiled output

License

MIT

This server cannot be installed

F
license - not found
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

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