Sqlc

What it does

The sqlc skill provides a specialized interface for AI agents to interact with SQL databases, enabling them to generate type-safe database drivers and queries directly from schema definitions. It streamlines the development workflow by automating the creation of Go, Rust, TypeScript, and other language-specific clients that map seamlessly to your database structure.

When to use it

• You need to rapidly generate boilerplate code for database interactions in supported languages like Go or TypeScript.
• Your team requires type-safe access to a PostgreSQL, MySQL, or SQLite database without manual schema parsing.
• You want to ensure database queries remain consistent with your evolving schema definitions.
• You are building an AI agent that needs direct, low-latency read/write capabilities against a relational store.

Key capabilities

• Generates type-safe drivers for multiple languages including Go, Rust, and TypeScript.
• Automatically creates CRUD operations based on provided SQL schemas.
• Supports major database engines such as PostgreSQL, MySQL, and SQLite.
• Produces idiomatic code that adheres to the specific conventions of the target language.

Example prompts

• "Generate a Go driver for my users table using the sqlc skill."
• "Create TypeScript types and queries for an inventory schema in PostgreSQL."
• "Write Rust functions to insert and update product records based on this SQL file."

Tips & gotchas

Ensure your database schema is up-to-date before generating code, as sqlc reflects the current state of your definitions. While it supports many languages, verify that your specific project stack is among the officially supported targets for the best results.