Database Toolbox

Reference repository for common database scripts and reusable DDL templates.

Structure

• mysql/: MySQL-specific scripts and templates
• mssql/: Microsoft SQL Server-specific scripts and templates
• shared/: Cross-engine conventions, snippets, and checklists

Key Folders

• references/: Frequently used operational scripts (backup, maintenance, security, etc.)
• templates/ddl/: DDL starter templates (tables, views, procedures, functions, triggers, indexes, constraints)

Included Script Packs

Each engine (mysql/, mssql/) includes starter scripts under:

• references/administration
• references/backup_restore
• references/data_migration
• references/maintenance
• references/security
• references/performance

Each engine also includes DDL templates under:

• templates/ddl/tables
• templates/ddl/views
• templates/ddl/stored_procedures
• templates/ddl/functions
• templates/ddl/triggers
• templates/ddl/indexes
• templates/ddl/constraints

Shared Guides

• shared/conventions/naming_conventions.md
• shared/checklists/deployment_checklist.md
• shared/snippets/transaction_patterns.md

Use these files as baseline templates and adapt schema names, table names, users/logins, and file paths per environment.