HorkerDataQuery

3.0.0

Horker DataQuery is an ADO.NET database query utility for Windows x64, supporting Windows PowerShell 5.1 (.NET Framework 4.8+) and PowerShell 7.6.5+ (.NET 10).

The main features are:
- Written in C# so that it works fast for large data
- Supports ADO.NET database providers, including SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DuckDB, Access, OLEDB and ODBC
- P
Horker DataQuery is an ADO.NET database query utility for Windows x64, supporting Windows PowerShell 5.1 (.NET Framework 4.8+) and PowerShell 7.6.5+ (.NET 10).

The main features are:
- Written in C# so that it works fast for large data
- Supports ADO.NET database providers, including SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DuckDB, Access, OLEDB and ODBC
- PowerShell interoperability; gets query results as PowerShell objects and exports PowerShell objects into database tables
- Reads app.config or web.config in your app to define database providers and connection strings
- Gets information from the database schema
- Includes SQLite on both hosts, with Npgsql and DuckDB additionally bundled on PowerShell 7

This module would be helpful for software development, data analysis, and various data manipulation tasks.

For more details, see the project site: https://github.com/horker/dataquery
Show more

Minimum PowerShell version

5.1

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name HorkerDataQuery

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name HorkerDataQuery

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2018-2026 horker. All rights reserved.

Package Details

Author(s)

  • horker

Tags

database relational rdb rdbms schema table column data analysis conversion query select insert update delete create drop sql server sqlserver oracle mysql postgresql firebird db2 sqlite duckdb access msaccess

Cmdlets

Invoke-DataQuery Get-DataQueryResult Export-DataTable Copy-DataRow New-DataConnection New-DataDatabase Close-DataConnection Get-DataConnectionHistory Register-DataConnectionString Unregister-DataConnectionString Get-DataConnectionString New-DataConnectionString Register-DbProviderFactory Unregister-DbProviderFactory Get-DbProviderFactory Register-DataConfiguration Get-DataSchema

PSEditions

Desktop Core

Dependencies

This module has no dependencies.

Release Notes

v3.0.0
- Resolve database file arguments from the current PowerShell location consistently across all cmdlets.
- Add New-DataDatabase to create empty SQLite or DuckDB files, with optional replacement and FileInfo output.
- Support Windows PowerShell 5.1 on .NET Framework 4.8+ alongside PowerShell 7.6.5+ on .NET 10 (Windows x64 only).
- Update dependencies, including SQLite 1.0.119 and Npgsql 10.0.3; isolate runtime-specific assemblies in one module package.
- Bundle DuckDB.NET.Data.Full 1.5.5 on PowerShell 7 for queries, row copies, exports and schema inspection, with a duckdb-memory connection.
- Improve provider registration, configuration updates, query column naming, rollback and connection cleanup; expand tests for both hosts.
- DuckDB reports -1 affected rows and rejects positive timeouts. Desktop does not bundle DuckDB or Npgsql; PostgreSQL can use an installed ODBC driver.

v2.1.0
- Bump SQLite library version to 1.0.117

v2.0.0
- Move to .NET Core and PowerShell Core
- Define Copy-DataRow

v1.0.5
- Releasing native resources (database connections) in more timely manner
- Improvements of data handling in Export-DataTable
- Query results as System.Data.DataTable
- Several improvements and bug fixes

v1.0.1 - v1.0.4
Bug fixes

v1.0.0
First release

FileList

  • HorkerDataQuery.nuspec
  • Assert-SupportedHost.ps1
  • HorkerDataQuery.psd1
  • HorkerDataQuery.psm1
  • lib\net10.0\Apache.Arrow.Scalars.dll
  • lib\net10.0\Apache.Arrow.dll
  • lib\net10.0\DuckDB.NET.Bindings.dll
  • lib\net10.0\DuckDB.NET.Data.dll
  • lib\net10.0\Horker.Data.deps.json
  • lib\net10.0\Horker.Data.dll
  • lib\net10.0\Horker.Data.pdb
  • lib\net10.0\Horker.Data.xml
  • lib\net10.0\Microsoft.Extensions.DependencyInjection.Abstractions.dll
  • lib\net10.0\Microsoft.Extensions.Logging.Abstractions.dll
  • lib\net10.0\Npgsql.dll
  • lib\net10.0\SQLite.Interop.dll
  • lib\net10.0\System.Configuration.ConfigurationManager.dll
  • lib\net10.0\System.Data.Odbc.dll
  • lib\net10.0\System.Data.OleDb.dll
  • lib\net10.0\System.Data.SQLite.dll
  • lib\net10.0\System.Data.SqlClient.dll
  • lib\net10.0\System.Diagnostics.EventLog.Messages.dll
  • lib\net10.0\System.Diagnostics.EventLog.dll
  • lib\net10.0\System.Diagnostics.PerformanceCounter.dll
  • lib\net10.0\System.Security.Cryptography.ProtectedData.dll
  • lib\net10.0\duckdb.dll
  • lib\net10.0\sni.dll
  • lib\net48\Horker.Data.dll
  • lib\net48\Horker.Data.pdb
  • lib\net48\Horker.Data.xml
  • lib\net48\System.Data.SQLite.dll
  • lib\net48\x64\SQLite.Interop.dll

Version History

Version Downloads Last updated
3.0.0 (current version) 10 9/8/2026
1.0.5 1,066 9/25/2018
1.0.4 76 3/31/2018
1.0.3 28 3/31/2018
1.0.2 30 3/30/2018
1.0.1 35 3/19/2018
1.0.0 31 3/18/2018
Show more