msf-database
/msf-database
Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification.
- Author
- Mustafa1998-tech ↗
- Repository
- msf-skills ↗
- Licence
- MIT
- Last repository change
- 12.11.2026
Assessment and security
- Files in this package
- 2
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 1
No signals detected. Repository changed on 12.11.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification.
Original author description
Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification.
How it works
- Scope
- Inputs
- Prerequisites
- Workflow
- Safety
- Outputs
- Validation
- Failure handling
- References
SKILL.md preview
--- name: msf-database description: "Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification." --- # msf-database ## Scope Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification. ## Inputs Schema, key queries, workload size, invariants and permitted environment. ## Prerequisites Inspect migration history, actual database engine/version, provider configuration and test data. ## Workflow 1. Define keys, referential integrity, uniqueness and nullability. Align transaction and concurrency policy with invariants. Inspect actual execution plans in a safe environment, compare reads and duration, and document index write costs. 2. Parameterize queries and procedures, handle legacy rows, and use expand/backfill/validate/contract where compatibility is needed. Test batch behavior, retry, contention and restore. Record backup and recovery assumptions with a restore rehearsal. ## Safety Require approval before live writes, data deletion or schema rollout. Use least privilege and redact data and plans before sharing. ## Outputs Migration, query or procedure, plan and measurements, data validation and rollback/restore steps. ## Validation Exercise forward migration on synthetic legacy data and verify constraints, concurrent writes, retry and rollback where supported. Capture real SQL Server evidence for engine-specific claims. ## Failure handling If the database is unavailable, run static checks or tests on available tooling and record SQL Server execution BLOCKED. ## References - [Field guide](references/field-guide.md) - [Primary source](https://learn.microsoft.com/en-us/sql/sql-server/)
Files in this package (2)
- SKILL.md 2 KB
- references/field-guide.md 1 KB
Versions
The database has no other skills named msf-database.
Database snapshot: 13.11.2026 · package version eb5db0df7d57 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 95sql-server
SQL Server and Azure SQL Database with T-SQL, indexes, stored procedures, and performance optimization patterns. USE WHEN: user mentions "SQL Server", "T-SQL", "MSSQL", "Azure SQL", "SQL Server indexes", "stored procedures", "SQL Server performance" DO NOT USE FOR: PostgreSQL -… - 100sql-development
T-SQL, stored procedures, and MS SQL Server DBA practices. Use when writing SQL queries, designing schemas, tuning SQL Server performance, managing backups, configuring security, or using SQL Server 2025+ features. - 90sql-optimization-patterns
Provides SQL optimization patterns for query performance, indexing strategies, schema design, and database tuning. Use when optimizing slow queries, designing indexes, or tuning database performance. - 95database
Guide database design, migration, and query optimization. Use when: schema design, migration planning, query optimization, index strategy. Not for: application code migration or framework upgrades — use /migrate; the API contract over the data — use /api-design. Keywords:… - 95sql-review
Reviewing SQL - what to flag, and what the database and linters actually check for you USE WHEN: you are reviewing, critiquing or auditing existing SQL - a "code review" of a query, a migration, a stored procedure, a view, or ORM-generated SQL in a diff or a PR; deciding what to… - 100orchardcore-sql-indexing
Skill for using SQL-based content indexing in Orchard Core. Covers content item indexing tables, field indexing tables, database schema reference, the ContentItemIndex SQL indexes including IDX_ContentItemIndex_ContentItemId, querying indexed data with C#, Razor views, Liquid…