cd /news/developer-tools/database-development-without-orm-a-p… · home › topics › developer-tools › article
[ARTICLE · art-100879] src=dev.to ↗ pub= topic=developer-tools verified=true sentiment=· neutral

Database Development Without ORM: A Pragmatic Approach to SQL-First Workflows

A developer has introduced a SQL-first workflow tool built on Kysely that allows developers to maintain typed queries while gaining support for stored procedures and table-valued parameters. The tooling includes safeguards for AI agent interactions with MCP support and per-agent role configurations to prevent destructive changes. A separate tool, Ignatius, handles data modeling and planning, supporting multiple schema description formats including IDEF1X.

read1 min views26 publishedAug 18, 2026

Many developers express frustration with ORM tooling, particularly around SQL migrations. The desire to work directly with SQL is common, yet existing solutions often fall short when handling testing, seeding, staging environments, and team onboarding.

A new approach addresses these pain points without introducing additional abstractions. The tooling is built on Kysely, allowing developers to maintain typed queries while gaining support for stored procedures and table-valued parameters. The JavaScript/TypeScript layer remains responsible for IO coordination and business logic, with the database layer handling schema management.

Key features include:

The platform includes safeguards for AI agent interactions, with built-in skills, MCP support, and per-agent role configurations. This prevents automated processes from making destructive changes to production environments while enabling efficient development workflows.

A separate tool, Ignatius, handles data modeling and planning. It supports multiple schema description formats, including IDEF1X with modern symbols, and is designed for iterative development. The markdown-based workflow allows developers to maintain context details for themselves and their LLM assistants.

This approach eliminates the translation layer between SQL and JavaScript, allowing developers to:

The solution provides a middle ground between raw SQL management and full ORM tooling, serving developers who prefer direct database interaction while still offering TypeScript integration and modern development workflow support.

── more in #developer-tools 4 stories · sorted by recency
── more on @kysely 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
→ Live at https://your-agent.zahid.host ✓
Get free account → Pricing
from €0/mo · no card required
LIVE [news/database-development…] indexed:0 read:1min 2026-08-18 · —