25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
use dbx_core::connection::AppState;
use std::sync::Arc;
use tauri::State;
#[tauri::command]
pub fn prepare_schema_diff(
options: dbx_core::schema_diff::SchemaDiffPreparationOptions,
) -> Result<dbx_core::schema_diff::SchemaDiffPreparation, String> {
Ok(dbx_core::schema_diff::prepare_schema_diff(options))
}
#[tauri::command]
#[allow(clippy::too_many_arguments)]
pub fn generate_schema_sync_sql(
diffs: Vec<dbx_core::schema_diff::TableDiff>,
function_diffs: Option<Vec<dbx_core::schema_diff::FunctionDiff>>,
sequence_diffs: Option<Vec<dbx_core::schema_diff::SequenceDiff>>,
rule_diffs: Option<Vec<dbx_core::schema_diff::RuleDiff>>,
owner_diffs: Option<Vec<dbx_core::schema_diff::OwnerDiff>>,
database_type: dbx_core::models::connection::DatabaseType,
target_schema: Option<String>,
cascade_delete: Option<bool>,
source_dialect: Option<dbx_core::sql_dialect::descriptor::DialectKind>,
field_mappings: Option<Vec<dbx_core::schema_diff::FieldMapping>>,
) -> Result<String, String> {
Ok(dbx_core::schema_diff::generate_schema_sync_sql(
&diffs,
function_diffs.as_deref().unwrap_or_default(),
sequence_diffs.as_deref().unwrap_or_default(),
rule_diffs.as_deref().unwrap_or_default(),
owner_diffs.as_deref().unwrap_or_default(),
database_type,
target_schema.as_deref(),
cascade_delete.unwrap_or(false),
source_dialect,
&field_mappings.unwrap_or_default(),
))
}
#[tauri::command]
#[allow(clippy::too_many_arguments)]
pub async fn generate_schema_sync_plan(
state: State<'_, Arc<AppState>>,
diffs: Vec<dbx_core::schema_diff::TableDiff>,
function_diffs: Option<Vec<dbx_core::schema_diff::FunctionDiff>>,
sequence_diffs: Option<Vec<dbx_core::schema_diff::SequenceDiff>>,
rule_diffs: Option<Vec<dbx_core::schema_diff::RuleDiff>>,
owner_diffs: Option<Vec<dbx_core::schema_diff::OwnerDiff>>,
database_type: dbx_core::models::connection::DatabaseType,
target_schema: Option<String>,
cascade_delete: Option<bool>,
source_dialect: Option<dbx_core::sql_dialect::descriptor::DialectKind>,
field_mappings: Option<Vec<dbx_core::schema_diff::FieldMapping>>,
enable_rollback: Option<bool>,
// Wrap the generated forward and rollback scripts in MySQL's FOREIGN_KEY_CHECKS
// toggle. Ignored for targets that are not MySQL.
ignore_foreign_key_checks: Option<bool>,
oracle_ddl: Option<dbx_core::schema_diff::OracleSchemaSyncDdlOptions>,
) -> Result<dbx_core::schema_diff::SchemaSyncSqlPlan, String> {
let oracle_ddl = if let Some(options) = oracle_ddl.as_ref().filter(|options| options.separate_indexes) {
if options.target.as_ref().is_none_or(|target| Some(target.schema.as_str()) != target_schema.as_deref())
|| !matches!(
database_type,
dbx_core::models::connection::DatabaseType::Oracle
| dbx_core::models::connection::DatabaseType::OceanbaseOracle
)
{
return Err("Independent indexes require the fixed Oracle target schema".into());
}
Some(
dbx_core::schema::prepare_schema_sync_oracle_ddl_core(
&state,
&diffs,
enable_rollback.unwrap_or(false),
options,
)
.await,
)
} else {
None
};
Ok(dbx_core::schema_diff::generate_schema_sync_sql_plan_with_oracle_ddl(
&diffs,
function_diffs.as_deref().unwrap_or_default(),
sequence_diffs.as_deref().unwrap_or_default(),
rule_diffs.as_deref().unwrap_or_default(),
owner_diffs.as_deref().unwrap_or_default(),
database_type,
target_schema.as_deref(),
cascade_delete.unwrap_or(false),
source_dialect,
&field_mappings.unwrap_or_default(),
enable_rollback.unwrap_or(false),
ignore_foreign_key_checks.unwrap_or(false),
oracle_ddl.as_ref(),
))
}