PerchIQX

The problem developers face:

You inherit a database. 50 tables. Zero docs. Where does user data live?

Traditional approach:

1. Draw ER diagrams manually

2. Write exploratory queries

3. Ask devs who left 2 years ago

PerchIQX approach:

Just ask Claude: "Show me all data for user 12345"

The MCP server:

- Introspects your D1 schema

- Maps foreign key relationships

- Understands data semantics

- Returns comprehensive analysis

Example queries that just work:

- "Find all tables referencing orders"

- "Validate schema for anti-patterns"

- "Suggest optimizations for tables with missing indexes"

Built with hexagonal architecture. 398 tests. Production-ready.

Questions? Ask away!

Part of Cormorant Foraging framework:

- ForageCast - Animation intelligence → indiehackers.com/product/foragecast

- PerchIQX (Space) - Database intelligence

- WakeIQX (Time) - Coming next week

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