Index of every page on this site: llms.txt
All skills
corey-alix avatar

/sql-js-database-assistant

@e4fbc1d
Run it yourself

Provides guidance for working with sql.js database operations, including query optimization, prepared statements, and schema management.

  • 1 file
  • 1.8 KB
  • Updated 9 months ago
  • GitHub
Use this Skill: https://skilld.dev/gh/corey-alix/dwp-hours/sql-js-database-assistant

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

SKILL.md

≈41 tokens for metadata: the name and description. ≈403 when used: this file.

Description uses 2.1% of example budget

Before choosing a Skill, your Agent reads its name and description. All available Skills share that space.

  • A shorter description leaves more room for other Skills. This entry exceeds our 1% size suggestion.

In our Claude Code example, all Skill names and descriptions share 8,000 characters. This Skill uses ≈164 characters, or 2.1%.

The 1% threshold is a size suggestion. Longer descriptions can still fit.

Your model, settings, and other Skills decide how much text your Agent can read.

Example settings and source

The example uses a 200k-token context and default Claude Code settings. The count includes the name, description, separators, and when_to_use when present. Codex also counts local file paths.

Skit's source and limits: Codex 0.160.1, Claude Code 2.1.292.

SQL.js Database Assistant

Description

Provides guidance for working with sql.js database operations, including query optimization, prepared statements, schema management, and SQLite best practices. Helps implement efficient database interactions for the DWP Hours Tracker application.

Trigger

Activated when users mention database operations, SQL queries, SQLite, prepared statements, schema changes, or ask about database performance, data persistence, or sql.js usage.

Response Pattern

  1. Analyze the database operation requirements and current schema structure
  2. Recommend appropriate sql.js patterns (prepared statements, transactions, proper error handling)
  3. Guide implementation of SQL queries with proper parameterization and indexing
  4. Suggest database optimization techniques and data integrity practices
  5. Ensure database operations align with project quality gates and TASKS/database-schema.md standards

Examples

  • "How do I write a prepared statement for inserting PTO entries?"
  • "What's the best way to query employee data with sql.js?"
  • "How do I handle database transactions safely?"
  • "My database query is slow, how can I optimize it?"
  • "How do I add a new table to the schema?"

Additional Context

This skill integrates with the completed TASKS/database-schema.md and follows sql.js official documentation best practices. Focuses on SQLite-specific optimizations, proper resource management, and reliable data persistence. Complements the existing database schema while ensuring all operations follow TypeScript strict mode and proper error handling patterns.

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No third-party reports yet.

Signed by skilld at e4fbc1d. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub last month.

Dormantupdated 9 months ago

README badge

README badge for corey-alix/dwp-hours/sql-js-database-assistant