GoSQLX
SQL validation, formatting, parsing, metadata extraction, linting, and security analysis.
사용해야 할까요
품질 및 안전성
도구 정의와 프로토콜 준수에 대한 자동 분석을 기반으로 합니다.
컨텍스트 비용
이는 서버의 도구가 모델의 컨텍스트에 로드될 때마다 소비되는 대략적인 토큰 수입니다. 수치가 높을수록 다른 작업에 사용할 수 있는 주의가 줄어듭니다.
설치
원클릭 설치
`claude_desktop_config.json` 파일에 다음을 추가하세요:
{
"mcpServers": {
"gosqlx": {
"url": "https://mcp.gosqlx.dev/mcp"
}
}
}원격 엔드포인트
https://mcp.gosqlx.dev/mcpstreamable-http할 수 있는 일
도구 목록
도구 (7)
🟢analyze_sql(sql)
Use this when the user wants a complete review of a SQL query. Runs validate, parse, metadata, security, lint, and format concurrently and returns one composite report; hosts that support MCP Apps render it as an interactive report.
입력 스키마
{
"type": "object",
"properties": {
"sql": {
"description": "The SQL string to analyze",
"type": "string"
}
},
"required": [
"sql"
]
}🟢extract_metadata(sql)
Use this when the user wants the tables, columns, and functions a SQL query references (e.g. for lineage or impact analysis). Returns {tables, columns, functions}.
입력 스키마
{
"type": "object",
"properties": {
"sql": {
"description": "The SQL string to analyze",
"type": "string"
}
},
"required": [
"sql"
]
}🟢format_sql(add_semicolon, indent_size, sql, uppercase_keywords)
Use this when the user wants SQL pretty-printed or reformatted: one clause per line, optional upper-case keywords and trailing semicolon. Comments are not kept. Returns {formatted_sql, options}.
입력 스키마
{
"type": "object",
"properties": {
"add_semicolon": {
"description": "Append a trailing semicolon (default: false)",
"type": "boolean"
},
"indent_size": {
"description": "Spaces per indent level for nested blocks such as CREATE TABLE columns; clauses always start at column 0. 0 puts each statement on one line (default: 2)",
"type": "number"
},
"sql": {
"description": "The SQL string to format",
"type": "string"
},
"uppercase_keywords": {
"description": "true upper-cases all SQL keywords (AND, IN, CASE, ...), but not data type names. false keeps the formatter's casing: clause keywords (SELECT, FROM, WHERE, ...) upper-case, other keywords (e.g. and, or) may keep their input case (default: false)",
"type": "boolean"
}
},
"required": [
"sql"
]
}🟢lint_sql(sql)
Use this when the user wants SQL style feedback. Applies the same 10 rules as `gosqlx lint`: L001 trailing whitespace, L002 mixed indentation, L003 consecutive blank lines, L004 indentation depth, L005 line length (>100), L006 column alignment, L007 keyword case (upper), L008 comma placement (trailing), L009 aliasing consistency, L010 redundant whitespace. Returns {violation_count, violations}.
입력 스키마
{
"type": "object",
"properties": {
"sql": {
"description": "The SQL string to lint",
"type": "string"
}
},
"required": [
"sql"
]
}🟢parse_sql(sql)
Use this when the user wants to know how SQL parses: returns an AST summary with the statement count and the type of each statement.
입력 스키마
{
"type": "object",
"properties": {
"sql": {
"description": "The SQL string to parse",
"type": "string"
}
},
"required": [
"sql"
]
}🟢security_scan(sql)
Use this when the user wants SQL checked for injection patterns: tautologies, UNION attacks, stacked queries, comment bypasses, and more. Returns findings with severity counts.
입력 스키마
{
"type": "object",
"properties": {
"sql": {
"description": "The SQL string to scan",
"type": "string"
}
},
"required": [
"sql"
]
}🟢validate_sql(dialect, sql)
Use this when the user wants to know whether a SQL statement is syntactically valid, optionally for a specific dialect. Returns {valid: bool, error?: string, dialect?: string}.
입력 스키마
{
"type": "object",
"properties": {
"dialect": {
"description": "SQL dialect: generic, postgresql, mysql, mariadb, sqlserver, oracle, sqlite, snowflake, bigquery, redshift, clickhouse",
"enum": [
"generic",
"postgresql",
"mysql",
"mariadb",
"sqlserver",
"oracle",
"sqlite",
"snowflake",
"bigquery",
"redshift",
"clickhouse"
],
"type": "string"
},
"sql": {
"description": "The SQL string to validate",
"type": "string"
}
},
"required": [
"sql"
]
}커뮤니티
증거