PerchIQX - Database schema intelligence for Cloudflare D1 via MCP

Model Context Protocol (MCP) server for Cloudflare D1 database introspection. Reference implementation of Semantic Intent patterns with domain-driven design.

4 AI-powered tools for Claude Desktop:

• analyze_database_schema - Complete structure + sample data

• get_table_relationships - Foreign keys, cardinality mapping

• validate_database_schema - Anti-patterns, missing indexes

• suggest_database_optimizations - Prioritized recommendations

Built with hexagonal architecture following Domain-Driven Design principles. 407 passing tests (Vitest). TypeScript with full type safety.

Key architectural layers:

• Domain Layer - Pure business logic (entities, services)

• Application Layer - Use cases and orchestration

• Infrastructure Layer - Cloudflare D1 REST API adapter

• Presentation Layer - MCP protocol handling

Production-ready. Open source (MIT). Reference implementation for AI-assisted database development.

Connect to Claude Desktop and ask: "Analyze my production database and suggest optimizations for tables with foreign keys."

GitHub: https://github.com/semanticintent/semantic-perch-intelligence-mcp

Docs: perchiqx.com