php-mcp

History

Snider 41b8568d5c test(mcp): add comprehensive SQL Query Validator tests (P2-013) Add Pest tests for SqlQueryValidator covering: - Allowed SELECT statements with WHERE, ORDER BY, LIMIT - Blocked data modification (INSERT, UPDATE, DELETE, TRUNCATE) - Blocked schema changes (DROP, ALTER, CREATE, RENAME) - Blocked permissions/admin (GRANT, REVOKE, FLUSH, KILL, SET) - Blocked execution (EXECUTE, PREPARE, CALL, DEALLOCATE) - Blocked file operations (INTO OUTFILE/DUMPFILE, LOAD_FILE/DATA) - SQL injection prevention: UNION attacks, stacked queries, time-based (SLEEP/BENCHMARK), encoding (hex/CHAR), subqueries, system table access, comment obfuscation - Query structure validation and whitelist configuration - Exception details and edge cases Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>	2026-01-29 19:38:40 +00:00
..
.gitkeep	Initial commit	2026-01-26 20:49:02 +00:00
SqlQueryValidatorTest.php	test(mcp): add comprehensive SQL Query Validator tests (P2-013)	2026-01-29 19:38:40 +00:00

Snider 41b8568d5c test(mcp): add comprehensive SQL Query Validator tests (P2-013)

Add Pest tests for SqlQueryValidator covering:
- Allowed SELECT statements with WHERE, ORDER BY, LIMIT
- Blocked data modification (INSERT, UPDATE, DELETE, TRUNCATE)
- Blocked schema changes (DROP, ALTER, CREATE, RENAME)
- Blocked permissions/admin (GRANT, REVOKE, FLUSH, KILL, SET)
- Blocked execution (EXECUTE, PREPARE, CALL, DEALLOCATE)
- Blocked file operations (INTO OUTFILE/DUMPFILE, LOAD_FILE/DATA)
- SQL injection prevention: UNION attacks, stacked queries,
  time-based (SLEEP/BENCHMARK), encoding (hex/CHAR), subqueries,
  system table access, comment obfuscation
- Query structure validation and whitelist configuration
- Exception details and edge cases

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

2026-01-29 19:38:40 +00:00

.gitkeep

Initial commit

2026-01-26 20:49:02 +00:00

SqlQueryValidatorTest.php

test(mcp): add comprehensive SQL Query Validator tests (P2-013)

2026-01-29 19:38:40 +00:00