skills.rest
DengNaichen
DengNaichenCOMMUNITY
Explore all skills by this author →
GitHub

axiom-audit-grdb-performance

Analyze Swift codebases for GRDB and SQLite performance anti-patterns and concurrency risks.

34|2|Updated Mar 16, 2026
Search Tags:#performance#database#audit#sqlite#swift#grdb
One-click install
npx skills add https://github.com/DengNaichen/Stet --skill axiom-audit-grdb-performance
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: axiom-audit-grdb-performance
Source: https://github.com/DengNaichen/Stet/tree/main/.agents/skills/axiom-audit-grdb-performance
Command: npx skills add https://github.com/DengNaichen/Stet --skill axiom-audit-grdb-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill identifies performance bottlenecks, concurrency issues, and SQLite anti-patterns in Swift applications using GRDB or SQLiteData, preventing production crashes and slow query performance.

Core Features & Use Cases

  • Performance Auditing: Detects missing indexes, lack of PRAGMA optimizations, and inefficient query patterns.
  • Concurrency Safety: Identifies risks related to multi-process database access, such as missing WAL mode or suspension notification handling.
  • Use Case: Before a release, use this skill to scan your codebase for potential SQL injection vectors, missing foreign key indexes, or Swift 6 concurrency violations in your database layer.

Quick Start

Run the axiom-audit-grdb-performance skill to perform a full audit of the database layer in the current repository.

Frequently Asked Questions about axiom-audit-grdb-performance

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I audit GRDB performance and SQLite correctness in a Swift codebase?▼

To audit GRDB performance and SQLite correctness, analyze your Swift codebase for missing indexes, inefficient query patterns, and PRAGMA optimization gaps. This process detects anti-patterns and concurrency risks to prevent slow queries and production crashes.

What are common SQLite concurrency risks in Swift applications using GRDB?▼

Common SQLite concurrency risks include missing WAL mode and inadequate suspension notification handling. These multi-process database access issues can cause data races and violations in your Swift 6 database layer, compromising application stability.

Does this database audit target raw SQLite implementations or only GRDB wrappers?▼

This database audit targets production-grade Swift applications using GRDB, SQLiteData, or raw SQLite implementations. It validates schema efficiency, indexing strategies, and transaction handling regardless of your specific SQLite abstraction layer.

When should I scan my Swift codebase for SQLite anti-patterns and performance bottlenecks?▼

You should scan your Swift codebase for SQLite anti-patterns and performance bottlenecks before a release. Running a full audit identifies potential SQL injection vectors and missing foreign key indexes early, ensuring schema efficiency and multi-process safety.

Related Skills

Explore More Software Engineering Skills→
pradeepmoulipradeepmouli

axiom-grdb

Provide type-safe SQLite access with GRDB for Swift apps.

Community
Advanced
randalmurphalrandalmurphal

sqlite-best-practices

Configure WAL mode and checkpoint timing for SQLite multiprocessing in Python.

Community
Advanced
mx-spacemx-space
547

mx-migration-author

Review SQL migration scripts for safety and correctness in rolling deploys.

Official
Advanced
nschneblenschneble

performance-optimization

Identify and fix Rails performance issues including N+1 queries and memory problems.

Community
Advanced