Data Generator is a powerful Visual Studio Code extension that allows you to easily generate realistic synthetic data for your databases using Google Gemini AI and Faker.js.
Features
Direct Database Connection: Connect directly to your MySQL or PostgreSQL databases.
Intelligent Schema Analysis: Automatically analyzes tables, columns, data types, and foreign key relationships.
Hybrid Data Generation:
Uses Google Gemini AI to generate contextual and realistic seed data.
Multiplies the seed data locally using Faker.js for high performance and volume.
Custom AI Prompts: Add custom instructions to the AI to tailor the data strictly to your business logic.
Usage
Open the Command Palette (Ctrl+Shift+P / Cmd+Shift+P).
Search and execute Data Generator: Open Panel.
Enter your database connection URI and click Connect.
Configure the number of rows for each table and optional AI settings.
Click Generate Data and watch your database fill with high-quality synthetic data!
Configuration
You can configure the following settings in VS Code:
dataGenerator.geminiApiKey: Your Google Gemini API Key for AI-powered data seeding.
dataGenerator.locale: Language locale (default: es_ES).
Requirements
VS Code version 1.85.0 or higher.
A valid Google Gemini API Key (if using the AI hybrid feature).