mithrandyr/SimplySql
55.3
Adequate · 28 September 2026
2.2k
lines of production code
VB.NET
primary language
4
measurements over time
What this system is
Features
Initial repository structure and build system
The repository was initialized with a new build automation script (default.build.ps1) that manages module composition, documentation generation, and versioning. Additionally, a .gitignore file was added to exclude build artifacts and user-specific files, and a VersionHistory.md was created to track release notes. These changes establish the foundational infrastructure for building and maintaining the SimplySql module.
(repo-wide) · high confidence
Introduce new cmdlets for SQL database interactions and connection management
The SimplySql.Cmdlets module now includes a comprehensive set of new cmdlets for managing SQL connections and executing queries. Users can open and close connections to MySQL, Oracle, PostgreSQL, SQLite, and SQL Server using dedicated \Open\*Connection\ cmdlets. The module also provides cmdlets for executing queries (\Invoke-SqlQuery\, \Invoke-SqlScalar\, \Invoke-SqlUpdate\), managing transactions (\Start-SqlTransaction\, \Complete-SqlTransaction\, \Undo-SqlTransaction\), and handling bulk copy operations (\Invoke-SqlBulkCopy\). Additional utility cmdlets allow users to get or set connection properties, retrieve messages, and test connection status.
source/SimplySql.Cmdlets · high confidence
SimplySql module v2.2.0 introduces provider-specific engine implementations
The SimplySql module (v2.2.0.106) now ships with a complete, provider-specific engine implementation for Microsoft SQL Server, MySQL, Oracle, PostgreSQL, and SQLite. This update introduces dedicated provider classes (e.g., MSSQLProvider, MySqlProvider) that handle connection management, query execution, and bulk data loading for each supported database system. The module manifest explicitly lists all exported cmdlets, including connection openers for each provider type, and defines aliases for common commands. This structural change enables the PowerShell cmdlets to interact with each database engine through a unified interface while preserving provider-specific optimizations and features.
ModuleManifest, source/SimplySql.Engine · high confidence
Test coverage
Added comprehensive test suites for all supported database providers
New automated tests have been added for MSSQL, MySQL, Oracle, PostgreSQL, and SQLite. These test scripts validate core SQL operations including scalar queries, updates, and result set retrieval, as well as bulk copy functionality with features like notifications, column mapping, and transaction support.
Tests · high confidence
Dependencies
SimplySql.Cmdlets and Engine projects added with .NET standard and multi-targeting support
The repository now includes project files for SimplySql.Cmdlets and SimplySql.Engine. The Cmdlets project targets .NET Standard 2.0 and references PowerShellStandard.Library 5.1.1. The Engine project targets .NET Standard 2.0, .NET Framework 4.7, and .NET 6.0, and includes package references for Azure.Identity 1.13.1, Microsoft.Data.SqlClient 5.2.2, MySqlConnector 2.4.0, Npgsql 8.0.6, Npgsql.NetTopologySuite 8.0.6, Oracle.ManagedDataAccess.Core 2.19.250, PowerShellStandard.Library 5.1.1, System.Data.DataSetExtensions 4.5.0, System.Data.SQLite.Core 1.0.119, System.Formats.Asn1 8.0.1, and System.Text.Json 8.0.5.
(dependencies) · medium confidence
Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
How this codebase got here
Score
- CAI 49 → 55 (+6.2)
- Rubric changed (rubric-2026.08.15 → rubric-2026.09.16) — scores are not directly comparable.
Lenses
- Code Health 93 → 97 (+4.0)
- Architecture 81 → 84 (+3.0)
- Maturity 55 → 46 (-9.3)
- Readiness 24 → 41 (+16.6)
- Security 100 → 100 (+0.0)
Resolved (10)
- Duplicated block (8 lines × 2) (source/SimplySql.Cmdlets/Cmdlets/InvokeSqlQuery.vb)
- LLM evaluation failed
- No automated tests
- No exposed public API
- No tests found
- Shell project: SimplySql.Cmdlets (source/SimplySql.Cmdlets/SimplySql.Cmdlets.vbproj)
- Shell project: SimplySql.Engine(net47) (source/SimplySql.Engine/SimplySql.Engine.vbproj)
- Shell project: SimplySql.Engine(net6.0) (source/SimplySql.Engine/SimplySql.Engine.vbproj)
- Shell project: SimplySql.Engine(netstandard2.0) (source/SimplySql.Engine/SimplySql.Engine.vbproj)
- Test reliability not included
New (5)
- Coverage not measured — no coverage collector is wired up
- Documentation: no project overview (Docs/SimplySql.md)
- Documentation: no project overview (Docs/Start-SqlTransaction.md)
- Duplicated block (8 lines × 2) (source/SimplySql.Cmdlets/Cmdlets/InvokeSqlQuery.vb)
- Orphaned files with no living knowledge
Architecture
- Unchanged — 1 containers · 0 contexts · 0 edges
Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
Survey your own repository
mithrandyr/SimplySql was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.
About this page
- The score is its most recent published measurement, taken on 28 September 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
- Measured at commit 3f6ca0716fb873114c12d7431b930767289b4d8a — the exact code this score is about.
- Scored under rubric-2026.09.16 — the same rubric and the same method as every other entry in this index.
- Measured by watchdog.canine.dev using codehealth-analyzer preprod-24a00d372a4b.