metis: Skill for Claude Code

Enterprise Infrastructure - Skills

Comprehensive guide to Kailash's progressive infrastructure model for scaling from single-process SQLite to multi-worker PostgreSQL/MySQL deployments.

Features

The enterprise infrastructure layer provides:

• Progressive Infrastructure Model: Level 0 (SQLite, in-process) to Level 2 (multi-worker, shared database + queue)
• QueryDialect Strategy Pattern: Dialect-portable SQL across PostgreSQL, MySQL 8.0+, and SQLite
• ConnectionManager: Async connection pooling with dialect-aware placeholder translation
• StoreFactory: Singleton factory for creating store backends from KAILASH_DATABASE_URL
• SQL Task Queue: Database-backed task queue using FOR UPDATE SKIP LOCKED
• Worker Registry: Heartbeat monitoring and dead worker reaping
• IdempotentExecutor: Exactly-once workflow execution via claim-execute-store pattern
• Schema Versioning: kailash_meta table with downgrade protection

Quick Start

# Level 0: Zero config (default)
from kailash.runtime import LocalRuntime
runtime = LocalRuntime()  # SQLite stores, in-process

# Level 1: Set KAILASH_DATABASE_URL=postgresql://user:pass@localhost/kailash
# Auto-detects PG, all stores use shared ConnectionManager

# Level 2: Set KAILASH_QUEUE_URL=redis://localhost:6379/0
# OR KAILASH_QUEUE_URL=postgresql://user:pass@localhost/kailash

The user's workflow code is identical at all levels.

Reference Documentation

Core Patterns

• progressive-infrastructure - Level 0/1/2 model, StoreFactory, env vars, schema versioning
• dialect-portable-sql - QueryDialect strategy, ? placeholders, _validate_identifier()
• connection-manager-patterns - ConnectionManager lifecycle, transactions, driver behavior

Operations

• task-queue-patterns - SQL task queue, SKIP LOCKED, Redis vs SQL, worker registry
• idempotency-patterns - IdempotentExecutor, claim-execute-store, TTL expiry