GenXdev.Data.SQLite provides comprehensive SQLite database access from PowerShell. It handles schema discovery, table and view data retrieval, transaction management, and query execution — plus it can launch SQLiteStudio for visual database work.
| Command | Aliases | What it does |
|---|---|---|
| New-SQLiteDatabase | nsqldb |
Create a new SQLite database file |
| Invoke-SQLiteQuery | — | Execute SQL queries with transaction support |
| Invoke-SQLiteStudio | — | Launch SQLiteStudio for visual database management |
| Get-SQLiteTables | — | List all tables in a database |
| Get-SQLiteTableSchema | — | Get the CREATE TABLE schema for a table |
| Get-SQLiteTableData | — | Retrieve rows from a table with optional limits |
| Get-SQLiteTableColumnData | — | Retrieve data from a specific column |
| Get-SQLiteViews | — | List all views in a database |
| Get-SQLiteViewSchema | — | Get the view definition |
| Get-SQLiteViewData | — | Retrieve rows from a view |
| Get-SQLiteSchema | — | Get the complete database schema at once |
| Get-SQLiteTransaction | getsqltx, newsqltx |
Create a transaction for batch operations |
New-SQLiteDatabase (nsqldb) creates a new SQLite database file.
Invoke-SQLiteQuery executes SQL statements against a database. The schema
discovery cmdlets (Get-SQLiteTables, Get-SQLiteTableSchema,
Get-SQLiteTableData, Get-SQLiteViews, Get-SQLiteViewSchema,
Get-SQLiteViewData, Get-SQLiteTableColumnData, Get-SQLiteViewColumnData,
Get-SQLiteSchema) let you explore database structure and data without
leaving PowerShell.
Get-SQLiteTransaction (getsqltx, newsqltx) creates a transaction object
for batch operations. Invoke-SQLiteStudio launches SQLiteStudio, a visual
database tool.
- GenXdev.Data.SqlServer — SQL Server counterpart with identical patterns
- GenXdev.Data.Preferences — Typed preferences system
- GenXdev.Data.KeyValueStore — Simpler JSON storage
- Full Cmdlet Reference