gi-database-query-patternsWrite database queries using tkms AsyncSqlSessionTemplate. Use when implementing dao layer, writing SQL, or when the user asks for database operations with i...
Install via ClawdBot CLI:
clawdbot install laimiaohua/gi-database-query-patternsGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Oct 7, 2026
A backend engineer building an order management microservice needs to write DAO methods for inserting orders, updating order status, querying order details by ID, and listing orders with pagination. Using tkms AsyncSqlSessionTemplate patterns, they can quickly implement insert, update, query_one, and query_list operations with proper parameterization and indexing. This reduces boilerplate and enforces consistency across the data access layer.
A full-stack developer working on a multi-tenant SaaS application needs to create CRUD operations for user profiles stored in MySQL. The skill provides ready-to-use patterns for inserting new users, updating profile fields by primary key, fetching single users, and listing users with status filters. It also guides index creation on frequently queried columns like status and create_time.
A logistics company is developing an inventory tracking backend that requires efficient queries for stock levels, batch inserts during restocking, and aggregate counts by status. The skill’s patterns for batch operations, transactions, and count queries help avoid N+1 issues and ensure atomicity. Proper indexing on warehouse_id and product_id is emphasized to maintain performance.
A healthcare software team is building a patient record management module with strict data integrity requirements. They use the skill’s transaction guidance to wrap batch updates in atomic operations, and parameterized SQL to prevent injection. The patterns for query_one and query_list support secure retrieval of patient data by ID and status.
A fintech startup needs to implement a DAO for logging financial transactions and generating summary reports. The skill provides patterns for inserting transaction entities, querying by date ranges with pagination, and counting records by status. Emphasis on indexing create_time and using parameterized queries ensures both performance and security.
Offer a subscription-based platform that provides developers with standardized database query patterns, code snippets, and integration with popular frameworks. The service includes automated DAO generation, performance monitoring, and best-practice updates. Revenue is generated through monthly or annual subscription fees tiered by team size and usage limits.
Sell an enterprise license for a proprietary framework that includes the AsyncSqlSessionTemplate and additional tooling for database operations, such as query analyzers, index advisors, and transaction managers. The license is priced per production server or per developer, with annual support contracts. This model targets large organizations needing compliance and scalability.
Provide expert consulting to help companies implement efficient database access layers using the skill’s patterns. Services include DAO code reviews, performance tuning, schema design, and migration to async frameworks. Revenue comes from project-based fees or retainer agreements for ongoing optimization.
💬 Integration Tip
Start by replacing direct SQL calls with AsyncSqlSessionTemplate methods, and always use parameterized queries to prevent injection. Ensure your database driver supports async operations and wrap batch updates in transactions for atomicity.
Scored Oct 7, 2026
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Pinecone vector database — manage indexes, upsert vectors, query similarity search, manage namespaces, and track collections via the Pinecone API. Build sema...
Connect, query, and monitor Redis instances. Use when checking key health, validating data types, generating backups, formatting results, linting configs.