tonic-skills

CLI-first skills for agents working with tonic.

This repo packages reusable agent skills for the current tonic workflow:

• saved targets with optional repo-local overrides
• query ping
• query inspect
• inline SQL execution
• query-file execution with tonic-file, tonic-bind, and tonic

The first release intentionally focuses on the CLI surface. It does not add a serve skill yet.

Requirements

• tonic >= 0.1.1
• a skills-capable agent such as OpenCode
• npx skills

Installation

Public installs should use the Forgejo HTTPS URL:

npx skills add https://forgejo.fairlabs.dev/ferrumboll/tonic-skills.git --list
npx skills add https://forgejo.fairlabs.dev/ferrumboll/tonic-skills.git --skill tonic-schema-explorer -a opencode -g -y
npx skills add https://forgejo.fairlabs.dev/ferrumboll/tonic-skills.git --skill '*' -a opencode -g -y

For local development from a checkout of the parent workspace:

npx skills add ./tonic-skills --list
npx skills add ./tonic-skills --skill tonic-query-files -a opencode -g -y

The public examples use HTTPS instead of the SSH remote so users do not need Forgejo keys just to install skills.

Included Skills

• tonic-target-bootstrap Set up saved targets in global config or a repo-local override, collect missing backend-specific fields, and verify the target with tonic query ping.
• tonic-schema-explorer Browse catalogs, namespaces, tables, views, columns, DDL, and view definitions using the inspect surface instead of guessing object shapes, including Snowflake descriptions when available.
• tonic-query-files Write and review tonic-file, tonic-bind, and tonic directives for multi-statement workflows.
• tonic-safe-execution Choose the right execution mode, handle writes carefully, and use transaction-aware file execution when inline SQL is too narrow.

Repository Layout

skills/
  tonic-target-bootstrap/
  tonic-schema-explorer/
  tonic-query-files/
  tonic-safe-execution/

Each skill is self-contained so selective installs do not rely on shared files outside the skill directory.

Development Notes

• Use npx skills add ./tonic-skills --list to verify discovery before pushing.
• Use targeted installs while iterating so you only reload the skill you are editing.
• Keep the repo text-only and small so remote installs stay fast.

0.1.2

• Document inspect description metadata, including Snowflake descriptions populated from object comments.