Unified Database Management for Every Engine

ChameleonDB: Your free, multi-engine database manager for Windows.

Effortlessly handle fundamental tasks like creating, editing, and querying databases, tables, and data across MySQL, PostgreSQL, SQLite, SQL Server, Oracle. Then, unlock truly advanced utilities: visual database design, schema comparison, cross-engine migration, smart relationship suggestions, and customizable table templates, streamlining your entire workflow.

Advanced Database Utilities

Smart Relationship Creation

Automatically suggests and creates related tables, foreign keys, and necessary indexes when new columns are added, based on naming conventions.

Database Comparison & Synchronization

Compare and synchronize the structure (schema) and data between two databases (potentially across different engines).

Cross-Engine Database Migration

Migrate a database's structure and data from one supported engine to another.

Visual Database Designer

A visual tool for designing entire database schemas, showing entity-relationship diagrams.

Table Templates

Apply predefined templates (e.g., standard primary keys, audit fields, tenant fields) when creating new tables to ensure consistency.

SQL Development & Execution

Integrated SQL Editor

A powerful editor for writing, editing, and executing SQL queries and DML/DDL commands.
Same features as Visual CODE.

Query Result Visualization

Charting capabilities to visualize query results directly within the application.

Multi-Result Set Handling

Supports execution of queries returning multiple result sets.

Streaming Query Results

Efficiently stream large query results for better performance.

Transaction Management

Execute commands within explicit transactions (BEGIN/COMMIT/ROLLBACK TRANSACTION).

Info Messages Capture

Captures and displays informational messages from the database engine (e.g., PRINT statements).

Database Object Design & Modeling (DDL Generation)

Comprehensive Database Design

Visually design and manage all core database objects.

View Design

Create, alter, and drop views, including a visual drag-and-drop designer.

Stored Procedure Management

Create, alter, and drop stored procedures, including parameter definitions.

Table Design

Create, alter, and drop tables with full control over: Columns, Primary Keys, Foreign Keys, Indexes,Default Values, Constraints, Support for Computed Columns.

User-Defined Function (UDF)

Create, alter, and drop scalar and table-valued functions, including parameter and return type definitions.

Trigger Management

Create, alter, and drop triggers for DML events (INSERT, UPDATE, DELETE), including support for AFTER and INSTEAD OF timings.

User-Defined Type (UDT) Support

View and manage user-defined data types and aliases

Schema Management

Create and drop schemas.

Scripting & Code Generation

Full Database Scripting

Generate comprehensive DDL scripts for an entire database, including schema-only or schema and data.

Database Object Scripting

Generate DDL scripts (CREATE, ALTER, DROP) for individual database objects (tables, views, stored procedures, functions, triggers, indexes, foreign keys, schemas, databases).

Conditional Scripting

Options to generate scripts with IF EXISTS/IF NOT EXISTS conditions for safer deployment.

Script Customization

Include/exclude comments, permissions, headers, and qualify object names.

Transactional Script Generation

Option to wrap generated DDL/DML scripts in a transaction block.

Object Documentation Scripting

Generate scripts to add, update, or drop extended properties/descriptions for tables and columns.

Data Management & Manipulation

ChameleonDB - Data management and manipulation

Data Editing

Directly edit data within any table or collection using a user-friendly interface.

Cascade Delete Assistant

A guided assistant for safely performing cascade deletions of records, respecting foreign key relationships.

Data Scripting

Generate INSERT, UPDATE, and DELETE DML scripts based on selected data rows.

DML Template Generation

Quickly generate empty SELECT, INSERT, UPDATE, and DELETE templates for any table.

Specialized Select Scripts

Generate SELECT statements by primary key or for specific foreign key relationships.