Ramakrishnan Ayyappan · Database Architect

Architecting resilient databases, scaling real-time data pipelines, and building AI systems that move, scale, and explain themselves.

I unite core database architecture, production data engineering, and intelligent AI operations. I specialize in designing high-performance schemas, cross-database synchronization, and real-time CDC streaming pipelines (Kafka, Debezium, Airflow) that move data seamlessly at scale. Combining deep database internals with enterprise observability, I build AI-powered operations, schema-aware AI agents, and custom SaaS tools so teams can query systems, automate work, and ship products—not just wrap a chatbot around a database.

Portrait of Ramakrishnan Ayyappan

Work

Systems I have built

All work
View system
DBSync schema comparison flowSource DBschema + rowsCompare enginetables · columns · typesTarget DBschema + rowsDiff · counts · hash drift

PostgreSQL · MySQL · Oracle

DBSync

Cross-database schema comparison, hash-based row validation, migration tooling, and CDC pipelines when engines or schemas differ.

View system
View system
AI diagnostics with MCP tools and n8n loopsOperatorchat / alertn8n loopsthink · retryPlannerMCP toolsread-only SQLThink loopreason firstSQL loopsingle or parallelError loopfix and retrySynthesize → operator

PostgreSQL · AI · Diagnostics

AI Database Diagnostics

An n8n diagnostics agent that loops through planning, MCP tool calls, and retries, then returns a finding an operator can act on.

View system
View system
MySQL Diag MCP read-only diagnostics pathMCP clientagent · Cursormysql-diag-mcpstdio · fixed toolsSSH pathbastion · CLIDirectPyMySQLMySQL metadata onlyinfo_schema · perf_schema · SHOWprocesslistlocksInnoDBdigestsrepl lagEXPLAIN

MySQL · MCP · Diagnostics

MySQL Diag MCP

Read-only MCP server for MySQL performance diagnostics—processlist, locks, InnoDB, digests, replication lag—via SSH or direct TCP.

View system

Notes

Writeups from the field

All writeups

AI Costs Are the New Cloud Bill

Most AI ops systems route every task through one expensive model. The cheaper path is task-model fit: rules, cache, small models, then escalate.

Designing the next layer of your data stack?

Architecture, migration planning, CDC design, or AI ops—send a short note and we can map the path from constraints to a working system.

Get in touch