Database Table Mapping Tool
Rename Columns & Generate SQL
Upload a database file, visually rename tables and columns, exclude fields you don't need, and generate a clean SQL migration script — all in your browser, no signup required.
Upload your database file
SQL, SQLite, CSV, JSON — up to 50 MB
Everything You Need to Map a Database Migration
Visual, fast and free — no SQL editing required to rename tables and columns.
Migrations Are More Than Just Format Conversion
When you migrate a database, you often need to do more than just change the file format. Legacy databases accumulate technical debt — columns named usr_nm instead of username, tables with deprecated fields that should be dropped, or naming conventions that do not match your new application.
The Table Mapping tool lets you clean all of that up visually before generating the migration script. No manual SQL editing, no risk of typos in column names, no hunting through a 500-line dump file.
Common use cases
- Renaming legacy columns to match a new naming convention
- Dropping deprecated columns before migrating to a new database
- Cleaning up a messy inherited schema before a refactor
- Generating a CREATE TABLE script with your preferred column names
- Preparing a schema for import into a different database engine
Map Your Database in Four Steps
The whole process takes under a minute for most databases.
Upload your file
Upload a SQL dump, SQLite file, CSV or JSON. The tool reads the schema and loads all tables and columns into the editor.
Rename tables & columns
Edit any table or column name directly in the mapping editor. Your changes are reflected in the generated SQL.
Exclude what you don't need
Uncheck any table or column to exclude it from the output. Only the fields you need end up in the migration script.
Generate & download
Click Generate SQL to produce a CREATE TABLE script with your mapping applied. Copy it or download it as a .sql file.
Common Questions
The Table Mapping tool generates a CREATE TABLE script based on your mapping choices. It handles the schema structure — table names, column names and types. To migrate the actual data rows, use the DB File Converter after mapping your schema.
SQL dump files, SQLite databases (.sqlite, .db, .sqlite3), CSV spreadsheets and JSON data files are all supported.
Yes. You can rename the table, rename any of its columns, and exclude any columns you do not need — all in the same mapping session before generating the SQL.
Excluded columns are simply omitted from the generated CREATE TABLE statement. They do not appear in the output SQL at all.
Yes. The output is a standard CREATE TABLE script you can import into MySQL, PostgreSQL or SQLite. You may need to adjust data types if you are targeting a different engine than the source.
No. The tool loads all tables from your uploaded file and lets you map all of them in a single session.
Other Free Database Tools
Ready to Map Your Database?
Upload your database file above, rename your tables and columns, and generate a clean migration script in under a minute. No account, no cost.