skills.rest
digirati-co-uk
digirati-co-ukOFFICIAL
Explore all skills by this author →
GitHub

db-queries

Standardize Madoc TS SQL query modules with Slonik templates and typed results.

57|15|Updated Nov 28, 2018
Search Tags:#typescript#documentation#codebase#queries#sql#madoc#slonik
One-click install
npx skills add https://github.com/digirati-co-uk/madoc-platform --skill db-queries
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-queries
Source: https://github.com/digirati-co-uk/madoc-platform/tree/main/.agents/skills/db-queries
Command: npx skills add https://github.com/digirati-co-uk/madoc-platform --skill db-queries

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill standardizes and documents Madoc TS SQL query modules to reduce inconsistencies and accelerate onboarding for developers extending or modifying queries in services/madoc-ts/src/database/queries or related SQL helpers.

Core Features & Use Cases

  • Establishes a uniform structure for query modules in services/madoc-ts/src/database/queries.
  • Documents conventions for Slonik sql templates, typed results, and helper usage.
  • Use Case: A new contributor adds a query module and follows the documented patterns to ensure compatibility with existing mappers and repositories.

Quick Start

Create or update a skill document to reflect the modular query pattern and follow the documented conventions.

Frequently Asked Questions about db-queries

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I standardize Slonik SQL query modules in a TypeScript codebase?▼

You standardize Slonik SQL query modules by applying a uniform modular pattern to files under services/madoc-ts/src/database/queries. This enforces consistent sql templates, typed results, and helper tag usage across the TypeScript codebase.

What conventions should I follow when adding queries to a Madoc TypeScript service?▼

When adding queries to a Madoc TypeScript service, follow conventions for Slonik sql templates, typed results, and repository integration. This reduces inconsistencies and accelerates onboarding for new contributors extending database functionality.

How does the Madoc TS database query structure work with mappers and repositories?▼

The database query structure conforms to Slonik sql templates and typed results, ensuring new query modules integrate seamlessly with existing mappers, repository patterns, and handler logic within the Madoc TS codebase.

Do I need to use Slonik to refactor database queries in the Madoc TS codebase?▼

Yes, you must use Slonik when refactoring database queries in the Madoc TS codebase. The established conventions require conforming to Slonik sql templates and helper tags to maintain consistency across query modules.

Why does my TypeScript SQL query module break existing repository integration?▼

Your TypeScript SQL query module may break repository integration if it deviates from the documented Slonik sql templates, typed results, and helper tag conventions established for the services/madoc-ts/src/database/queries directory.

Related Skills

Explore More Software Engineering Skills→
digirati-co-ukdigirati-co-uk
57

db-migrations

Manage Madoc TypeScript database migrations with the Slonik migrator.

Official
Intermediate
salvo-rssalvo-rs
20

salvo-testing

Validate Salvo handlers, middleware, and routing with TestClient.

Official
Intermediate
madooeimadooei
1

create-repository

Define a typed repository interface for CRUD data access in TypeScript services.

Community
Intermediate
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced