OrcaSql
A C# parser for MDF files. Allows you to read tables, metadata and indexes from MDF files without it being attached to a running SQL Server instance.
Install / Use
/learn @ycherkes/OrcaSqlREADME
This repository has reached the maintenance state: "You need it, you fix it". If you find a bug or need a new feature, please feel free to create a Pull Request.
OrcaSql
OrcaSql is a parser for Microsoft SQL Server data files. It allows you to read SQL Server data files without the use of SQL Server.
This solution is based on existing Mark's S. Rasmussen repository https://github.com/improvedk/OrcaMDF with the following enhancements:
- modern data types support (Xml, HierarchyId, Geography, Geometry, DateTime2, DateTimeOffset);
- improved formatting of the data shown in grid;
- caching system tables only;
- large databases support (tested on the Stack Overflow 2014 database https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/);
- schema added to names of the tables and data types;
- fixed some bugs (like usage of pg_first - it works mainly for the sample DBs, but doesn't for real DBs, bug with multiple bit columns - https://github.com/improvedk/OrcaMDF/issues/32 etc.);
- ability to generate an SQL script to fix corrupted page of database based on the page data from the file;
- ability to export the data of the table from the backup to the SQL Server for further analysis;
- columns with zero physical length (with default constraints);
- skipping dropped column data;
- skipping ghost ang ghost forwarded records;
- external plugins support;
- collation support;
- SQL syntax highlighting;
- similar to SSMS NULL value highlighting;
- performance optimization.
Related Skills
oracle
353.3kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
353.3kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
111.7kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
111.7kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
