Skip to content
Skills Library
Data & analytics · Building & coding

msf-database

/msf-database

Use for SQL Server, T-SQL, EF Core, schema, stored procedures, indexing, query optimization or migration. Prefer engine-native verification.

Repository
msf-skills ↗
Licence
MIT
Last repository change
12.11.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
2
Scripts
0
HTML comments
0
URLs in SKILL.md
1
Deprecation

No signals detected. Repository changed on 12.11.2026, without references to retired models or APIs.

Licence

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

  1. Scope
  2. Inputs
  3. Prerequisites
  4. Workflow
  5. Safety
  6. Outputs
  7. Validation
  8. Failure handling
  9. References
Original SKILL.md headings · 41 lines, 204 words
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…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.