skills.rest
Vinix24
Vinix24COMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Vinix24/vnx-orchestration --skill database-engineer-vinix24
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
HarriesHarries
1

design-export-db

Export MySQL table structures and DDL via MCP queries.

Community
Advanced
wojonswojons
4

testing-database

Test database schemas, migrations, and data integrity with automated scripts.

Community
Intermediate
oriolriusoriolrius
17

Drizzle ORM

Define type-safe schemas and queries for SQLite, PostgreSQL, and MySQL.

Community
Advanced
script-reposcript-repo

AgentDB Advanced Features

Enable distributed AgentDB capabilities with QUIC sync and hybrid search.

Community
Advanced