Route GORM reads to replicas and writes to primary databases.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-dbresolver
Please help me install this Agent Skill. Skill: gorm-dbresolver Source: https://github.com/liurida/gorm-development-skill/tree/main/dbresolver Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-dbresolver
GORM applications that need to scale with multiple databases often struggle to manually manage read/write routing, connection switching, and load balancing, leading to complex and error‑prone code.
Configure GORM with the dbresolver plugin to route writes to the primary database and reads to replica databases.
High-intent search queries and answers about installing and using this skill.
Read-write splitting in GORM is configured by registering the dbresolver plugin with primary source and replica dialectors, enabling automatic routing of writes to primary databases and reads to replicas.
Yes, you can plug in custom load balancing policies for replica selection, allowing algorithms like round-robin or weighted distribution to control how reads are distributed across multiple database replicas.
Transaction consistency is maintained because all operations within a transaction use the same connection, preventing accidental connection switching between primary and replica databases during active transactions.
You can manually override automatic routing by using provided clauses to force reads or writes on specific database connections, bypassing the default read-write splitting behavior when needed.
Yes, different models or tables can be assigned to distinct resolver groups, enabling database sharding or domain separation by routing specific models to dedicated primary and replica database configurations.
Using dbresolver eliminates the complex and error-prone code required to manually manage read/write routing, connection switching, and load balancing across multiple databases in scalable GORM applications.
liuridaExpose GORM database metrics to Prometheus for monitoring.
Orchestra-ResearchIntegrate PyTorch FSDP2 with DTensor sharding and DCP checkpointing into training scripts.
qiphonOptimize MCP server latency with connection pooling and load balancing.
thapaliyabikendraProvide system design patterns for scalable distributed systems.
