TableSmith_テーブル作成支援ツール

# TableSmith

TableSmith is a Windows desktop application that supports database table design.
You can input table design information such as tables, columns, primary keys, foreign keys, and indexes on the screen, and output them as CREATE TABLE statements, Excel table definition documents, and ER diagrams.

App Overview

TableSmith is a tool designed to streamline database design work required in business system development.

You can organize table physical names, logical names, descriptions, columns, data types, sizes, Not Null constraints, default values, primary keys, foreign keys, and more on the screen, and output SQL and design documents based on that information.

It supports CREATE TABLE statement output for SQL Server, MySQL, and Oracle, and can switch and output identifiers, data types, comment syntax, and auto-increment clauses for each RDBMS.

Furthermore, you can manage default RDB, schema, character encoding, and collation on a per-project basis, and set schema names, character encoding, and collation for each table. Decimal type precision/decimal places, auto-increment, protection targets, protection methods, index definitions, and more can be handled as design information.

The created design information can be saved and loaded as .tablesmith.json, allowing you to maintain the design state during development or edit it later.

Main Features

• Create and edit table definitions
• Create and edit column definitions
• Set primary keys and foreign keys
• Set schema names, character encoding, and collation
• Set decimal type precision and decimal places
• Auto-increment settings
• Protection target and protection method design notes
• Index definitions
• CREATE TABLE statement output for SQL Server / MySQL / Oracle
• SQL file output
• Excel table definition document output
• ER diagram preview
• Save ER diagrams as SVG / PNG
• Project JSON save and load
• Configuration completion for legacy version JSON
• Update checking for installer version

Recommended For

• People who want to streamline DB design for business systems
• People who want to reduce the work of creating table definition documents in Excel
• People who want to reduce discrepancies between CREATE TABLE statements and design documents
• People who want to quickly shape DB design for small to medium-sized systems
• People who want to organize table definitions for SQL Server, MySQL, and Oracle
• People who want to save and develop existing design information as JSON

How to Use

1. Enter the project name.
2. Set the default RDB, schema, character encoding, and collation as needed.
3. From the table definition creation screen, input table information and column information.
4. Set primary keys, foreign keys, Not Null, default values, auto-increment, decimal precision, etc.
5. Add index definitions as needed.
6. Confirm and edit created definitions in the table list.
7. Output CREATE TABLE statements, Excel definition documents, and ER diagrams.
8. Save the project as .tablesmith.json.

Outputs

• CREATE TABLE statements
• SQL files for each table
• Excel table definition documents
• ER diagram preview
• ER diagram SVG
• ER diagram PNG
• TableSmith project JSON

Technology Stack

• C#
• .NET 10
• WPF
• MahApps.Metro
• ClosedXML
• log4net
• WpfAnimatedGif
• Velopack

Operating Environment

It is a desktop application for Windows.
The .NET 10 Desktop Runtime is required to run it.

Installation

Download and run the installer from GitHub Releases.
In the installer version, you can check for new versions from "Check for Updates" in the app.

Development Background

In DB design, table definitions, SQL, Excel design documents, and ER diagrams are often created separately, which makes information discrepancies and rework likely to occur.

TableSmith consolidates table design information in one place and outputs SQL, Excel, and ER diagrams from there, aiming to simplify design work and improve speed and accuracy in the early stages of development.

Features to Add in the Future

• Retrieve tables from existing databases
• Generate ALTER scripts when tables change
• Create test data
• Support for stored procedure creation
• Enhanced output for encryption and masking design