Write SQLite queries and schemas enforcing lowercase CTEs and strict tables.
npx skills add https://github.com/maragudk/skills --skill sql-maragudk
Please help me install this Agent Skill. Skill: sql Source: https://github.com/maragudk/skills/tree/main/sql Command: npx skills add https://github.com/maragudk/skills --skill sql-maragudk
This Skill provides guidance for working with SQLite databases, covering query writing, schema design, and SQLite-specific best practices.
Write a simple SELECT from a small SQLite schema using the conventions described to fetch data.
High-intent search queries and answers about installing and using this skill.
SQLite queries should use lowercase syntax, Common Table Expressions (CTEs) instead of deeply nested subqueries, and strict tables. This approach improves readability, maintainability, and query performance while keeping code consistent across your schema.
Use strict tables with standardized timestamps formatted as strftime('%Y-%m-%dT%H:%M:%fZ'), primary keys like id text primary key default ('p_' || lower(hex(randomblob(16)))), and automatic updated timestamp triggers. This ensures data integrity and predictable schema behavior.
Migrations apply schema changes systematically using SQL files that define tables, constraints, and triggers. Integrate migrations into your Go application startup to ensure schema consistency across environments before executing queries.
Yes. SQLite works efficiently with Go for query writing, schema design, and database integration. Follow conventions like lowercase queries, CTEs, strict tables, and standardized timestamps to maintain clean, maintainable database code.
Nested subqueries reduce readability and query optimization. Common Table Expressions (CTEs) break complex logic into named, reusable steps that are easier to understand, debug, and optimize for SQLite's query planner.
Use ISO 8601 format via strftime('%Y-%m-%dT%H:%M:%fZ') for all timestamps. This standardized format ensures consistent data representation, simplifies cross-system interoperability, and allows reliable sorting and comparison.
recca0120Create and migrate SQLite and MySQL schemas with Drizzle ORM.
besoeasyQuery SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.
R2W1csOptimize Prisma ORM schemas, migrations, queries, connections, and transactions.
oakossDefine SQL schemas and query databases with TypeScript type safety.
