SimplySql

2.0.4.75

Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.

SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done.  The basic pattern is to connect to a database, execute one or more sql
Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.

SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done.  The basic pattern is to connect to a database, execute one or more sql statements and then close your database connection.  This module provides cmdlets that map to this basic pattern.  Each provider has its own Open-*Connection cmdlet -> Open-SqlConnection, Open-SQLiteConnection, Open-OracleConnection, Open-PostGreConnection, Open-MySqlConnection.  The rest of the commands are provider agnostic.

Open/Close/Show/Test/Set/Get -SqlConnection >> Control as many active connections as you want.
Invoke- SqlScalar/SqlQuery/SqlUpdate >> Interact with those connections.
Get/Clear -SqlMessage >> Get Informational messages, if provider supports it.
Invoke-SqlBulkCopy >> Bulk Dataload from one connection to another.
Start/Complete/Undo -SqlTransaction >> Utilize transactions!
Show more

Minimum PowerShell version

5.0

Installation Options

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

Install-Module -Name SimplySql

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

Install-PSResource -Name SimplySql

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) 2022 Mithrandyr. All rights reserved.

Package Details

Author(s)

  • Mithrandyr

Tags

SQL SQLite Database Oracle MySql PostGre Npgsql MSSQL

Cmdlets

Clear-SqlMessage Close-SqlConnection Complete-SqlTransaction Get-SqlConnection Get-SqlMessage Get-SqlTransaction Invoke-SqlBulkCopy Invoke-SqlQuery Invoke-SqlScalar Invoke-SqlUpdate Open-MySqlConnection Open-OracleConnection Open-PostGreConnection Open-SQLConnection Open-SQLiteConnection Set-SqlConnection Show-SqlConnection Start-SqlTransaction Test-SqlConnection Undo-SqlTransaction

Dependencies

This module has no dependencies.

Release Notes

Currently Supporting Microsoft SQL, SQLite, MySql, PostGre and Oracle.  Check project repository for full Release Notes.  Latest addition is support for PostGIS Geometry datatype in PostGreSQL.

FileList

  • SimplySql.nuspec
  • EnumerableToDataReader.dll
  • bin\Microsoft.SqlServer.Server.dll
  • bin\System.Diagnostics.DiagnosticSource.dll
  • bin\System.Text.Json.dll
  • bin\linux-x64\System.Text.Encoding.CodePages.dll
  • bin\win-x64\System.Runtime.Caching.dll
  • bin\linux-x64\de\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\de\Microsoft.Data.SqlClient.resources.dll
  • SimplySql.Cmdlets.dll
  • bin\MySqlConnector.dll
  • bin\System.Diagnostics.PerformanceCounter.dll
  • bin\System.Text.RegularExpressions.dll
  • bin\osx-x64\Microsoft.Data.SqlClient.dll
  • bin\win-x64\System.Runtime.Extensions.dll
  • bin\linux-x64\es\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\es\Microsoft.Data.SqlClient.resources.dll
  • SimplySql.Common.dll
  • bin\NetTopologySuite.dll
  • bin\System.DirectoryServices.dll
  • bin\System.Threading.Channels.dll
  • bin\osx-x64\Microsoft.Win32.Registry.dll
  • bin\win-x64\System.Security.AccessControl.dll
  • bin\linux-x64\fr\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\fr\Microsoft.Data.SqlClient.resources.dll
  • bin\NetTopologySuite.IO.PostGis.dll
  • bin\System.DirectoryServices.Protocols.dll
  • bin\System.Threading.dll
  • bin\osx-x64\SQLite.Interop.dll
  • bin\win-x64\System.Security.Cryptography.Cng.dll
  • bin\linux-x64\it\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\it\Microsoft.Data.SqlClient.resources.dll
  • SimplySql.psd1
  • bin\Npgsql.dll
  • bin\System.Globalization.dll
  • bin\System.Threading.Tasks.dll
  • bin\osx-x64\System.Data.SQLite.dll
  • bin\win-x64\System.Security.Cryptography.ProtectedData.dll
  • bin\linux-x64\ja\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\ja\Microsoft.Data.SqlClient.resources.dll
  • bin\Azure.Core.dll
  • bin\Npgsql.NetTopologySuite.dll
  • bin\System.IdentityModel.Tokens.Jwt.dll
  • bin\System.Threading.Tasks.Extensions.dll
  • bin\osx-x64\System.IO.FileSystem.AccessControl.dll
  • bin\win-x64\System.Security.Principal.Windows.dll
  • bin\linux-x64\ko\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\ko\Microsoft.Data.SqlClient.resources.dll
  • bin\Azure.Identity.dll
  • bin\Oracle.ManagedDataAccess.dll
  • bin\System.IO.dll
  • en-US\about_SimplySql.help.txt
  • bin\osx-x64\System.Private.Uri.dll
  • bin\win-x64\System.Text.Encoding.CodePages.dll
  • bin\linux-x64\pt-BR\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\pt-BR\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Bcl.AsyncInterfaces.dll
  • bin\SimplySql.Common.dll
  • bin\System.Management.Automation.dll
  • en-US\SimplySql.Cmdlets.dll-Help.xml
  • bin\osx-x64\System.Runtime.Caching.dll
  • bin\win-x86\Microsoft.Data.SqlClient.dll
  • bin\linux-x64\ru\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\ru\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Bcl.HashCode.dll
  • bin\SimplySql.Engine.dll
  • bin\System.Memory.Data.dll
  • bin\linux-x64\Microsoft.Data.SqlClient.dll
  • bin\osx-x64\System.Runtime.Extensions.dll
  • bin\win-x86\Microsoft.Data.SqlClient.SNI.dll
  • bin\linux-x64\zh-Hans\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\zh-Hans\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.CSharp.dll
  • bin\SimplySql.Providers.MSSQL.dll
  • bin\System.Memory.dll
  • bin\linux-x64\Microsoft.Win32.Registry.dll
  • bin\osx-x64\System.Security.AccessControl.dll
  • bin\win-x86\Microsoft.Win32.Registry.dll
  • bin\linux-x64\zh-Hant\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x64\zh-Hant\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Extensions.DependencyInjection.Abstractions.dll
  • bin\SimplySql.Providers.MySql.dll
  • bin\System.Numerics.Vectors.dll
  • bin\linux-x64\SQLite.Interop.dll
  • bin\osx-x64\System.Security.Cryptography.Cng.dll
  • bin\win-x86\SQLite.Interop.dll
  • bin\osx-x64\de\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\de\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Extensions.Logging.Abstractions.dll
  • bin\SimplySql.Providers.Oracle.dll
  • bin\System.Reflection.dll
  • bin\linux-x64\System.Data.SQLite.dll
  • bin\osx-x64\System.Security.Cryptography.ProtectedData.dll
  • bin\win-x86\System.Data.SQLite.dll
  • bin\osx-x64\es\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\es\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Identity.Client.dll
  • bin\SimplySql.Providers.PostGre.dll
  • bin\System.Reflection.Primitives.dll
  • bin\linux-x64\System.IO.FileSystem.AccessControl.dll
  • bin\osx-x64\System.Security.Principal.Windows.dll
  • bin\win-x86\System.IO.FileSystem.AccessControl.dll
  • bin\osx-x64\fr\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\fr\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.Identity.Client.Extensions.Msal.dll
  • bin\SimplySql.Providers.SQLite.dll
  • bin\System.Resources.ResourceManager.dll
  • bin\linux-x64\System.Private.Uri.dll
  • bin\osx-x64\System.Text.Encoding.CodePages.dll
  • bin\win-x86\System.Runtime.Caching.dll
  • bin\osx-x64\it\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\it\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.Abstractions.dll
  • bin\System.Buffers.dll
  • bin\System.Runtime.CompilerServices.Unsafe.dll
  • bin\linux-x64\System.Runtime.Caching.dll
  • bin\win-x64\Microsoft.Data.SqlClient.dll
  • bin\win-x86\System.Runtime.Extensions.dll
  • bin\osx-x64\ja\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\ja\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.JsonWebTokens.dll
  • bin\System.Collections.dll
  • bin\System.Runtime.dll
  • bin\linux-x64\System.Runtime.Extensions.dll
  • bin\win-x64\Microsoft.Data.SqlClient.SNI.dll
  • bin\win-x86\System.Security.AccessControl.dll
  • bin\osx-x64\ko\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\ko\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.Logging.dll
  • bin\System.Collections.Immutable.dll
  • bin\System.Runtime.Loader.dll
  • bin\linux-x64\System.Security.AccessControl.dll
  • bin\win-x64\Microsoft.Win32.Registry.dll
  • bin\win-x86\System.Security.Cryptography.Cng.dll
  • bin\osx-x64\pt-BR\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\pt-BR\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.Protocols.dll
  • bin\System.Configuration.ConfigurationManager.dll
  • bin\System.Security.Permissions.dll
  • bin\linux-x64\System.Security.Cryptography.Cng.dll
  • bin\win-x64\SQLite.Interop.dll
  • bin\win-x86\System.Security.Cryptography.ProtectedData.dll
  • bin\osx-x64\ru\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\ru\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
  • bin\System.Data.Common.dll
  • bin\System.Text.Encoding.dll
  • bin\linux-x64\System.Security.Cryptography.ProtectedData.dll
  • bin\win-x64\System.Data.SQLite.dll
  • bin\win-x86\System.Security.Principal.Windows.dll
  • bin\osx-x64\zh-Hans\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\zh-Hans\Microsoft.Data.SqlClient.resources.dll
  • bin\Microsoft.IdentityModel.Tokens.dll
  • bin\System.Data.DataSetExtensions.dll
  • bin\System.Text.Encodings.Web.dll
  • bin\linux-x64\System.Security.Principal.Windows.dll
  • bin\win-x64\System.IO.FileSystem.AccessControl.dll
  • bin\win-x86\System.Text.Encoding.CodePages.dll
  • bin\osx-x64\zh-Hant\Microsoft.Data.SqlClient.resources.dll
  • bin\win-x86\zh-Hant\Microsoft.Data.SqlClient.resources.dll

Version History

Version Downloads Last updated
2.0.4.75 (current version) 234,078 6/15/2024
2.0.3.73 55,510 5/11/2024
2.0.2.70 107,088 3/2/2024
2.0.1.69 327 3/1/2024
2.0.0.67 25,225 2/9/2024
1.9.1 665,760 1/29/2023
1.9.0 214,626 5/28/2022
1.8.0 124,043 4/2/2021
1.7.0 4,933 2/16/2021
1.6.2 64,287 2/26/2019
1.6.1 122 2/7/2019
1.6.0 61 2/7/2019
1.5.9 216 11/27/2018
1.5.4 155 10/5/2018
1.5.2 83 9/18/2018
1.5.1 57 9/4/2018
1.4.1 248 6/11/2018
1.4.0 1,253 5/16/2018
1.3.8 51 5/11/2018
1.3.7 42 5/9/2018
1.3.6 96 3/24/2018
1.3.5 42 3/22/2018
1.3.3 61 3/19/2018
1.3.2 122 2/12/2018
1.3.1 37 2/12/2018
1.3.0 39 2/12/2018
1.2.0 94 1/8/2018
1.1.1 100 11/30/2017
Show more