stacks-query-builder

Construct type-safe SQL queries with a fluent API for Stacks applications.

2|Updated Jul 8, 2026
One-click install
npx skills add https://github.com/bughq/bughq --skill stacks-query-builder-bughq
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: stacks-query-builder
Source: https://github.com/bughq/bughq/tree/main/.claude/skills/stacks-query-builder
Command: npx skills add https://github.com/bughq/bughq --skill stacks-query-builder-bughq

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill simplifies database interactions by providing a fluent, type-safe interface for constructing SQL queries, reducing the complexity of manual query writing and raw SQL management.

Core Features & Use Cases

  • Fluent Query API: Build complex SELECT, INSERT, UPDATE, and DELETE statements using a chainable, readable syntax.
  • Configuration Management: Centralized control over database dialects, pagination, soft deletes, and transaction retries.
  • Use Case: When developing a new feature, use this skill to quickly draft a query that joins multiple tables, applies filters, and handles pagination without writing boilerplate SQL.

Quick Start

Use the stacks-query-builder skill to construct a database query that selects active users from the database and orders them by name in ascending order.

Frequently Asked Questions about stacks-query-builder

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

FAQPage Schema
How do I build type-safe SQL queries in a TypeScript application?

You can build type-safe SQL queries using a fluent API to construct complex SELECT, INSERT, UPDATE, and DELETE statements, reducing boilerplate SQL. It provides centralized configuration for joins, aggregates, and transaction management.

How do I write a database query that joins multiple tables and handles pagination?

Drafting a query that joins multiple tables and handles pagination is achieved through a chainable, fluent API. This method allows you to apply filters and manage pagination without writing raw SQL manually.

Does the Stacks query builder support multiple database dialects and transaction management?

Yes, the query builder supports multiple database dialects and transaction management. It provides centralized control over configurations including dialects, pagination, soft deletes, and transaction retries.

Can I use Bun with a fluent query builder for database operations?

Yes, you can use Bun with a fluent query builder by integrating the required bun-query-builder package. This setup allows you to execute complex database operations type-safely within your applications.

What is the best way to manage soft deletes and database configurations in TypeScript?

The best way to manage soft deletes and database configurations is using a centralized control interface provided by a fluent query builder. This allows you to easily configure dialects, pagination, and transaction retries.