Average Ratings 2 Ratings

Total
ease
features
design
support

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

Introducing a versatile and free database management tool designed for developers, database administrators, analysts, and anyone who engages with databases. It offers compatibility with a wide range of popular databases, including MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, among others. Recent updates include a new format configuration editor for the "Copy As" feature, enhanced performance through additional configurations in the filter dialog, and the ability to sort by column with fixed settings for smaller fetch sizes. Users can now benefit from case-insensitive filters, while the plaintext view has been improved by incorporating top and bottom dividers. Furthermore, the data editor has been rectified to address issues arising from column name conflicts with alias names, and the command for duplicating rows has been fixed for cases involving multiple selections. The context menu has been updated to include the edit sub-menu once again, and auto-sizing configurations for columns have been introduced. Additionally, the dictionary viewer has been corrected for use with read-only connections, and new features support current and selected row highlighting, which can be customized according to user preferences. This tool continues to evolve, ensuring that users have the best possible experience while working with their database management tasks.

Description

SchemaSmith is a comprehensive toolset designed for managing database schemas in SQL Server, PostgreSQL, MySQL, and MariaDB environments. By defining your ideal database configuration through metadata, including tables, views, procedures, indexes, constraints, and reference data, SchemaSmith seamlessly adjusts any target server to align with this specification, eliminating the need for manual migration scripts. The toolset features several components: SchemaTongs for extracting a database's schema into version-controlled packages, SchemaQuench for deploying those packages to designated servers, DataTongs for delivering reference data, and SchemaShears for creating object-level patch subsets. Notably, it is provided as a self-sufficient, single-file command-line executable compatible with Windows, macOS, and Linux, meaning no additional runtime installation is necessary. This streamlined approach enhances user efficiency while minimizing setup complications.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

No images available

Integrations

MariaDB Yes 
MySQL Yes 
PostgreSQL Yes 
SQL Server Yes 
Amazon Athena Yes 
CrateDB Yes 
Devart ODBC Drivers Yes 
Firebird Yes 
IBM Db2 Yes 
IBM Informix Yes 
LocalStack Yes 
Microsoft Access Yes 
MongoDB Yes 
Oracle Cloud CX Yes 
Phoenix Yes 
PostgresML Yes 
Presto Yes 
SAP Cloud Platform Yes 
SQLite Yes 
Salesforce Data 360 Yes 

Integrations

MariaDB Yes 
MySQL Yes 
PostgreSQL Yes 
SQL Server Yes 
Amazon Athena No 
CrateDB No 
Devart ODBC Drivers No 
Firebird No 
IBM Db2 No 
IBM Informix No 
LocalStack No 
Microsoft Access No 
MongoDB No 
Oracle Cloud CX No 
Phoenix No 
PostgresML No 
Presto No 
SAP Cloud Platform No 
SQLite No 
Salesforce Data 360 No 

Pricing Details

$11/month
Monthly subscription starts at $11
Annual subscription starts at $110
Free Trial Yes 
Free Version No 

Pricing Details

$0
Free Trial No 
Free Version Yes 

Deployment

Web-Based No 
On-Premises Yes 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars Yes 
Live Training (Online) Yes 
In Person Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

DBeaver Corp.

Founded

2017

Country

United States

Website

dbeaver.io

Vendor Details

Company Name

SchemaSmith, LLC

Founded

2025

Country

United States

Website

schemasmith.com

Product Features

Database

Backup and Recovery Yes 
Creation / Development Yes 
Data Migration Yes 
Data Replication No 
Data Search Yes 
Data Security Yes 
Database Conversion No 
Mobile Access No 
Monitoring Yes 
NOSQL Yes 
Performance Analysis Yes 
Queries Yes 
Relational Interface Yes 
Virtualization No 

Alternatives

Alternatives

DbSchema Reviews

DbSchema

Wise Coders
AutosyncDB Reviews

AutosyncDB

DreamTeam
Luna Modeler Reviews

Luna Modeler

Ideamerit