database-engineer

Guide SQLite schema migrations and performance tuning for multi-tenant systems.

56|6|Updated Jan 19, 2026

Search Tags:#performance #schema design #migration #sqlite #index optimization #fts5

Ready to run

npx skills add https://github.com/Vinix24/vnx-orchestration --skill database-engineer-vinix24

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-engineer
Source: https://github.com/Vinix24/vnx-orchestration/tree/main/skills/database-engineer
Command: npx skills add https://github.com/Vinix24/vnx-orchestration --skill database-engineer-vinix24

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the challenges of managing complex SQLite databases during schema migrations, ensuring data consistency, safety, and performance.

Core Features & Use Cases

Schema migrations and data integrity: Guides writing safe migration scripts for multi-tenant and multi-source SQLite schemas.
Debugging and performance optimization: Assists with EXPLAIN QUERY PLAN analysis, index recommendations, and FTS rebuild strategies.
Use Case: When updating a large multi-tenant database with new constraints or indexing, this Skill ensures robust, efficient, and correct changes.

Quick Start

Use the database-engineer skill to understand and optimize your SQLite migration scripts for performance and safety.

Frequently Asked Questions about database-engineer

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

FAQPage Schema

How do I write safe SQLite migration scripts for multi-tenant databases?▼

Writing safe SQLite migration scripts for multi-tenant databases requires careful transaction handling and constraint validation to ensure data integrity. This Skill provides guidance on structuring schema migrations to prevent data loss and maintain consistency across multiple tenants.

What is the best way to optimize SQLite index performance using EXPLAIN QUERY PLAN?▼

Optimizing SQLite index performance using EXPLAIN QUERY PLAN involves analyzing query execution paths to identify missing or inefficient indexes. This Skill assists with interpreting EXPLAIN QUERY PLAN output and recommends index optimization strategies for complex queries.

How does FTS5 rebuild procedure work in SQLite and when should I use it?▼

FTS5 rebuild procedures in SQLite reconstruct full-text search indexes when underlying schema changes or corruption occurs. This Skill offers strategies for executing FTS5 rebuilds safely to ensure search functionality remains reliable after database modifications.

Can I use SQLite schema design techniques for complex multi-source data systems?▼

SQLite schema design can support complex multi-source data systems by enforcing strict data integrity constraints and careful index planning. This Skill delivers expert schema design guidance tailored for managing reliable data across multiple sources and tenants.

Why does my SQLite database migration fail during transaction handling?▼

SQLite database migrations often fail during transaction handling due to improper constraint validation or locking conflicts. This Skill helps debug migration failures by providing robust transaction handling strategies and safe migration script patterns.