SqlLabDataGenerator
2.0.0
AI-assisted synthetic data generation platform for SQL Server, SQLite, DuckDB and every other PSSqlRepository provider. Discovers database schema, classifies columns semantically (with OpenAI, Azure OpenAI, or Ollama), generates realistic FK-consistent test data with locale support (en-US, cs-CZ, ...), context-dependent JSON/XML generation via cross-column AI dependen
AI-assisted synthetic data generation platform for SQL Server, SQLite, DuckDB and every other PSSqlRepository provider. Discovers database schema, classifies columns semantically (with OpenAI, Azure OpenAI, or Ollama), generates realistic FK-consistent test data with locale support (en-US, cs-CZ, ...), context-dependent JSON/XML generation via cross-column AI dependencies, and transforms output to Entra ID objects and other formats.
Show more
Minimum PowerShell version
7.4
Installation Options
Owners
Copyright
Copyright (c) 2026 i-system
Package Details
Author(s)
- Ondrej Kracmar
Tags
SQL SqlServer SQLite DuckDB PSSqlRepository TestData SyntheticData DataGeneration LabData Database AI Ollama OpenAI DataMasking DevOps Testing EntraID Locale i18n Windows Linux MacOS
Functions
Clear-SldgCache Connect-SldgDatabase Disconnect-SldgDatabase Export-SldgGenerationProfile Export-SldgTransformedData Get-SldgAIProvider Get-SldgColumnAnalysis Get-SldgDatabaseSchema Get-SldgHealth Get-SldgPromptTemplate Get-SldgSession Get-SldgTransformer Import-SldgGenerationProfile Invoke-SldgDataGeneration New-SldgGenerationPlan Register-SldgLocale Register-SldgTransformer Remove-SldgPromptTemplate Reset-SldgSession Set-SldgAIProvider Set-SldgGenerationRule Set-SldgPromptTemplate Test-SldgAIProvider Test-SldgGeneratedData
PSEditions
Dependencies
-
- PSFramework (>= 1.12.346)
- PSSqlRepository (>= 0.5.0)
Release Notes
https://github.com/ondrejkracmar/SqlLabDataGenerator/blob/main/changelog.md
FileList
- SqlLabDataGenerator.nuspec
- SqlLabDataGenerator.psd1
- SqlLabDataGenerator.psm1
- bin\assembly.ps1
- bin\net10.0\SqlLabDataGenerator.deps.json
- bin\net10.0\SqlLabDataGenerator.dll
- bin\net10.0\SqlLabDataGenerator.pdb
- bin\net10.0\SqlLabDataGenerator.xml
- bin\net8.0\SqlLabDataGenerator.deps.json
- bin\net8.0\SqlLabDataGenerator.dll
- bin\net8.0\SqlLabDataGenerator.pdb
- bin\net8.0\SqlLabDataGenerator.xml
- en-us\about_SqlLabDataGenerator.help.txt
- en-us\strings.psd1
- functions\ai\Get-SldgAIProvider.ps1
- functions\ai\Get-SldgPromptTemplate.ps1
- functions\ai\Remove-SldgPromptTemplate.ps1
- functions\ai\Set-SldgAIProvider.ps1
- functions\ai\Set-SldgPromptTemplate.ps1
- functions\ai\Test-SldgAIProvider.ps1
- functions\connection\Clear-SldgCache.ps1
- functions\connection\Connect-SldgDatabase.ps1
- functions\connection\Disconnect-SldgDatabase.ps1
- functions\connection\Get-SldgSession.ps1
- functions\connection\Reset-SldgSession.ps1
- functions\generation\Invoke-SldgDataGeneration.ps1
- functions\generation\New-SldgGenerationPlan.ps1
- functions\generation\Set-SldgGenerationRule.ps1
- functions\generation\Test-SldgGeneratedData.ps1
- functions\locale\Register-SldgLocale.ps1
- functions\profile\Export-SldgGenerationProfile.ps1
- functions\profile\Import-SldgGenerationProfile.ps1
- functions\schema\Get-SldgColumnAnalysis.ps1
- functions\schema\Get-SldgDatabaseSchema.ps1
- functions\transform\Export-SldgTransformedData.ps1
- functions\transform\Get-SldgTransformer.ps1
- functions\transform\Register-SldgTransformer.ps1
- functions\utility\Get-SldgHealth.ps1
- internal\configurations\configuration.ps1
- internal\configurations\locale-cs-CZ.ps1
- internal\configurations\locale-en-US.ps1
- internal\configurations\providers.ps1
- internal\functions\generation\ConvertTo-SldgTableInfo.ps1
- internal\functions\generation\Disable-SldgCircularFKConstraint.ps1
- internal\functions\generation\Enable-SldgCircularFKConstraint.ps1
- internal\functions\generation\Get-SldgAIPlanAdvice.ps1
- internal\functions\generation\Get-SldgAISchemaAnalysis.ps1
- internal\functions\generation\Get-SldgExistingUniqueValue.ps1
- internal\functions\generation\Get-SldgGenerationQualityReport.ps1
- internal\functions\generation\Get-SldgGeneratorMap.ps1
- internal\functions\generation\Get-SldgPostInsertPrimaryKeyValue.ps1
- internal\functions\generation\Get-SldgScenarioTemplate.ps1
- internal\functions\generation\Group-SldgTablesByLevel.ps1
- internal\functions\generation\Initialize-SldgGenerationContext.ps1
- internal\functions\generation\Invoke-SldgMaskingTable.ps1
- internal\functions\generation\Invoke-SldgParallelTableGeneration.ps1
- internal\functions\generation\Invoke-SldgStreamingGeneration.ps1
- internal\functions\generation\New-SldgAIGeneratedBatch.ps1
- internal\functions\generation\New-SldgFKContextAwareBatch.ps1
- internal\functions\generation\New-SldgGeneratedValue.ps1
- internal\functions\generation\New-SldgRowSet.ps1
- internal\functions\generation\Resolve-SldgForeignKeyFallback.ps1
- internal\functions\generation\Set-SldgPrimaryKeyStartValue.ps1
- internal\functions\generation\Write-SldgAuditRecord.ps1
- internal\functions\generators\New-SldgAIStructuredValue.ps1
- internal\functions\generators\New-SldgAddress.ps1
- internal\functions\generators\New-SldgCompany.ps1
- internal\functions\generators\New-SldgDate.ps1
- internal\functions\generators\New-SldgEmail.ps1
- internal\functions\generators\New-SldgFinancial.ps1
- internal\functions\generators\New-SldgIdentifier.ps1
- internal\functions\generators\New-SldgNumber.ps1
- internal\functions\generators\New-SldgPersonName.ps1
- internal\functions\generators\New-SldgPhone.ps1
- internal\functions\generators\New-SldgStaticJson.ps1
- internal\functions\generators\New-SldgStaticXml.ps1
- internal\functions\generators\New-SldgStructuredData.ps1
- internal\functions\generators\New-SldgText.ps1
- internal\functions\locale\Get-SldgLocaleData.ps1
- internal\functions\locale\New-SldgAILocaleCategory.ps1
- internal\functions\locale\New-SldgAILocaleData.ps1
- internal\functions\locale\Register-SldgLocaleInternal.ps1
- internal\functions\providers\Connect-SldgRepositorySession.ps1
- internal\functions\providers\Disconnect-SldgRepositorySession.ps1
- internal\functions\providers\Get-SldgProviderInternal.ps1
- internal\functions\providers\Invoke-SldgDbQuery.ps1
- internal\functions\providers\Read-SldgTableData.ps1
- internal\functions\providers\Register-SldgBuiltInProvider.ps1
- internal\functions\providers\Register-SldgProviderInternal.ps1
- internal\functions\providers\Update-SldgTableData.ps1
- internal\functions\providers\Write-SldgTableData.ps1
- internal\functions\providers\schema\Get-SldgInformationSchema.ps1
- internal\functions\providers\schema\Get-SldgSqlServerSchema.ps1
- internal\functions\providers\schema\Get-SldgSqliteSchema.ps1
- internal\functions\schema\ConvertTo-SldgCanonicalDataType.ps1
- internal\functions\schema\ConvertTo-SldgSchemaModel.ps1
- internal\functions\schema\Resolve-SldgForeignKeyOrder.ps1
- internal\functions\semantic\Build-SldgRelationshipGraph.ps1
- internal\functions\semantic\Get-SldgAIColumnAnalysis.ps1
- internal\functions\semantic\Get-SldgColumnClassification.ps1
- internal\functions\semantic\Invoke-SldgAIRequest.ps1
- internal\functions\semantic\Resolve-SldgSemanticType.ps1
- internal\functions\transformers\ConvertTo-SldgEntraIdGroup.ps1
- internal\functions\transformers\ConvertTo-SldgEntraIdUser.ps1
- internal\functions\transformers\Register-SldgTransformerInternal.ps1
- internal\functions\utility\Assert-SldgConnectionOpen.ps1
- internal\functions\utility\Convert-PsfMessageTarget.ps1
- internal\functions\utility\Get-SldgSafeSqlName.ps1
- internal\functions\utility\Invoke-SldgCacheEviction.ps1
- internal\functions\utility\Remove-SldgUnsafeChar.ps1
- internal\functions\utility\Resolve-SldgPromptTemplate.ps1
- internal\functions\utility\Test-SldgCacheExpired.ps1
- internal\functions\validation\Test-SldgDataTypeConstraints.ps1
- internal\functions\validation\Test-SldgForeignKeyIntegrity.ps1
- internal\functions\validation\Test-SldgUniqueConstraints.ps1
- internal\prompts\batch-generation.default.prompt
- internal\prompts\column-analysis.default.prompt
- internal\prompts\locale-category.default.prompt
- internal\prompts\locale-data.default.prompt
- internal\prompts\plan-advice.default.prompt
- internal\prompts\schema-analysis.default.prompt
- internal\prompts\structured-value-contextual.default.prompt
- internal\prompts\structured-value.default.prompt
- internal\scriptblocks\scriptblocks.ps1
- internal\scripts\license.ps1
- internal\scripts\postimport.ps1
- internal\scripts\preimport.ps1
- internal\scripts\strings.ps1
- internal\tepp\SqlLabDataGenerator.tepp.ps1
- internal\tepp\assignment.ps1
- types\SqlLabDataGenerator.Types.ps1xml
- views\SqlLabDataGenerator.Format.ps1xml
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 2.0.0 (current version) | 4 | 9/12/2026 |