exposed-r2dbc

What problem does it solve?

This Skill eliminates the steep learning curve and repetitive boilerplate work of implementing reactive database access with JetBrains Exposed, R2DBC, and Kotlin Coroutines, helping developers avoid common pitfalls and accelerate production-ready reactive backend development.

Core Features & Use Cases

• Reactive SQL DSL Patterns: Pre-built, production-grade patterns for table definition, DML operations (INSERT, SELECT, UPDATE, DELETE) using Exposed's R2DBC Flow API, compatible with H2, PostgreSQL, MySQL, and MariaDB.
• Coroutine-First Transaction Management: Ready-to-use suspendTransaction patterns and test infrastructure for safe, efficient coroutine-based database workflows in Spring WebFlux or Ktor applications.
• Cross-Dialect Testing: Parameterized test templates for validating database code across multiple SQL dialects without rewriting test logic.
• Use Case: A developer building a reactive e-commerce backend can use this Skill to quickly implement a multi-tenant product repository with caching and routing datasource patterns, backed by automated cross-database tests.

Quick Start

Use the exposed-r2dbc skill to implement a reactive user repository with suspendTransaction and multi-database parameterized tests for your Kotlin Exposed R2DBC project.