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.