🇰🇷 Korean • 🇺🇸 English

⬇️ Releases • ☕ Support

• 1. Introduction
• 2. Key Features
• 3. Getting Started
• 4. User Guide
• 5. Tech Stack
• 6. Developer Guide
• 7. Advanced Configuration
• 8. Contributing
• 9. License
• 10. Contact & Support

Here’s Dummy is a desktop application that automatically analyzes database schemas and utilizes AI or Faker.js to generate realistic, high-volume dummy data. It allows you to quickly secure the necessary data during development and testing phases, significantly boosting productivity.

Here’s Dummy offers features for dummy data generation and DB performance testing.

• Schema Auto-Analysis: Automatically identifies table structures, constraints, and relationships (FK).
• Multi-Database Support: Can connect to various DBs like MySQL and PostgreSQL to generate data.
• High-Speed Bulk Generation: Capable of generating 100,000 records in approximately 10 seconds using Faker.js.
• AI-Powered Generation: Utilizes GPT, Claude, and Gemini to generate smart, contextually relevant data.
• File-Based Data Conversion: Upload CSV, TXT, or JSON files to convert and insert data matching the DB structure.

• Index Test: Analyzes the efficiency of your database indexes.

• User Query Test: Analyzes query performance and recommends improvement measures.

• Test History: Allows you to check the history of completed tests.

  
  

The latest release is available for download from the Releases page.

• Run the heresdummy-setup.exe file.

Click the + button to create a project and enter connection details for MySQL, PostgreSQL, etc. You can check the connection status beforehand via Test Connection.

Once the DB is connected, the table list is automatically analyzed and displayed. Select a table for data generation and set the desired method for each column, such as Faker (random values), AI (intelligent generation), or File Upload.

Enter the number of rows to generate and press the Generate Data button. The generated results can be Exported to SQL file or Inserted directly into DB.

You can analyze the efficiency of your database indexes by clicking the Start Test button in the Index Test tab.

Indexes are classified as Normal, Recommended, or Critical based on criteria. For indexes classified as Recommended or Critical, issues and improvement suggestions are displayed. Try deleting unused or inefficient indexes.

In the User Query Test tab, you can click the Start Test button, enter the SQL you want to test, set the number of executions and a timeout, and then proceed with the test.

Syntax validation can be used to check if the query is valid. Even if not checked, syntax validation is performed upon starting the test, ensuring only valid queries are tested.

The test results provide average response time and response time distributions such as P50 and P95. It also analyzes the query execution plan to show how the query is processed.

Click the AI response generation button to receive recommendations for improving the query. Improve complex queries, such as subqueries and joins, and add necessary indexes more efficiently.

In the Test History tab, you can view the history of tests performed. Compare the results and use them for your portfolio.

• Core: Electron, React, TypeScript, Vite
• Database: mysql2, pg
• Data Generation: @faker-js/faker, openai, @anthropic-ai/sdk, @google/generative-ai
• State Management: zustand

• Node.js 18+
• npm or yarn

# 1. Clone the repository
git clone https://github.com/yuja201/here-is-dummy.git
cd here-is-dummy

# 2. Install dependencies
npm install

# 3. Set up .env file
cp .env.example .env
# Add your API keys to the .env file

# 4. Run development server
npm run dev

To change advanced settings for the AI generation feature (BASE_URL, TIMEOUT, etc.):

Windows

C:\Users\{USERNAME}\AppData\Roaming\Here's Dummy\.env

Open the .env file at this path with a text editor to modify the following settings. If using GMS, be sure to change the endpoint:

# API Endpoints
OPENAI_BASE_URL=https://api.openai.com/v1
ANTHROPIC_BASE_URL=https://api.anthropic.com
GOOGLE_BASE_URL=https://generativelanguage.googleapis.com

# Timeout settings (milliseconds)
OPENAI_TIMEOUT=60000
ANTHROPIC_TIMEOUT=60000
GOOGLE_TIMEOUT=60000

# Maximum retries
OPENAI_MAX_RETRIES=2
ANTHROPIC_MAX_RETRIES=2
GOOGLE_MAX_RETRIES=2

The settings will be applied after restarting the application.

We welcome various contributions to the Here’s Dummy project! Bug reports and feature suggestions can be registered on the Issues page.

🇰🇷 Korean Manual    🇺🇸 English Guide

This project follows the MIT License.

• Bug Reports & Feature Suggestions: GitHub Issues
• Other Inquiries: Google Forms

If you find this project useful, please give it a Star ⭐!