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 serde::{Deserialize, Deserializer, Serialize};
use serde_json::Value;
pub const PROTOCOL_VERSION: u32 = 2;
pub const LEGACY_SESSION_ID: &str = "__legacy__";
pub const DEFAULT_MAX_ROWS: usize = 10_000;
pub const MAX_AGENT_SESSIONS: usize = 256;
pub const MAX_CONCURRENT_REQUESTS: usize = 64;
#[derive(Debug, Deserialize)]
pub struct RpcRequest {
#[serde(default)]
pub id: Value,
pub method: String,
#[serde(default)]
pub params: Value,
}
#[derive(Debug, Serialize)]
pub struct RpcResponse {
pub jsonrpc: &'static str,
pub id: Value,
#[serde(skip_serializing_if = "Option::is_none")]
pub result: Option<Value>,
#[serde(skip_serializing_if = "Option::is_none")]
pub error: Option<RpcError>,
}
#[derive(Debug, Serialize)]
pub struct RpcError {
pub code: i32,
pub message: String,
#[serde(skip_serializing_if = "Option::is_none")]
pub data: Option<StructuredError>,
}
#[derive(Debug, Serialize)]
#[serde(rename_all = "camelCase")]
pub struct StructuredError {
pub category: &'static str,
pub retryable: bool,
pub session_disposition: &'static str,
pub stage: &'static str,
pub contract_version: u32,
pub operation_outcome: &'static str,
#[serde(skip_serializing_if = "Option::is_none")]
pub agent_session_id: Option<String>,
#[serde(skip_serializing_if = "Option::is_none")]
pub exception_class: Option<String>,
}
#[derive(Debug, Clone, Default, Deserialize)]
pub struct ConnectParams {
#[serde(default)]
pub host: String,
#[serde(default)]
pub port: u16,
#[serde(default)]
pub database: String,
#[serde(default)]
pub username: String,
#[serde(default)]
pub password: String,
#[serde(default)]
pub url_params: String,
#[serde(default)]
pub connection_string: String,
#[serde(default)]
pub ssl: bool,
#[serde(default)]
pub ca_cert_path: String,
#[serde(default)]
pub client_cert_path: String,
#[serde(default)]
pub client_key_path: String,
#[serde(default)]
pub connect_timeout_secs: u64,
}
#[derive(Debug, Clone, Default, Deserialize)]
pub struct QueryOptions {
#[serde(default)]
pub sql: String,
#[serde(default)]
pub database: String,
#[serde(default)]
pub schema: String,
#[serde(default, rename = "maxRows")]
pub max_rows: usize,
#[serde(default, rename = "fetchSize")]
pub fetch_size: usize,
#[serde(default, rename = "timeoutSecs")]
pub timeout_secs: u64,
#[serde(default, rename = "pageSize")]
pub page_size: usize,
}
#[derive(Debug, Clone, Default, Deserialize)]
pub struct MetadataListConstraints {
#[serde(default)]
pub filter: String,
#[serde(default)]
pub limit: usize,
#[serde(default)]
pub offset: usize,
#[serde(default)]
pub object_types: Vec<String>,
}
#[derive(Debug, Clone, Default, Deserialize)]
pub struct CompletionAssistantRequest {
#[serde(default)]
pub database: String,
#[serde(default, deserialize_with = "deserialize_null_default")]
pub schema: String,
#[serde(default)]
pub object_kinds: Vec<String>,
#[serde(default)]
pub mask: String,
#[serde(default)]
pub case_sensitive: bool,
#[serde(default)]
pub global_search: bool,
#[serde(default, deserialize_with = "deserialize_null_default")]
pub max_results: usize,
#[serde(default, deserialize_with = "deserialize_null_default")]
pub parent_schema: String,
#[serde(default, deserialize_with = "deserialize_null_default")]
pub parent_name: String,
#[serde(default, deserialize_with = "deserialize_null_default")]
pub match_mode: String,
}
fn deserialize_null_default<'de, D, T>(deserializer: D) -> Result<T, D::Error>
where
D: Deserializer<'de>,
T: Deserialize<'de> + Default,
{
Ok(Option::<T>::deserialize(deserializer)?.unwrap_or_default())
}
#[derive(Debug, Serialize)]
pub struct HandshakeResult {
#[serde(rename = "protocolVersion")]
pub protocol_version: u32,
#[serde(rename = "agentProtocolVersion")]
pub agent_protocol_version: u32,
pub capabilities: Vec<&'static str>,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct DatabaseInfo {
pub name: String,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct TableInfo {
pub name: String,
pub table_type: String,
pub comment: Option<String>,
pub parent_schema: Option<String>,
pub parent_name: Option<String>,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct ObjectInfo {
pub name: String,
pub object_type: String,
pub schema: String,
pub comment: Option<String>,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct ColumnInfo {
pub name: String,
pub data_type: String,
pub is_nullable: bool,
pub column_default: Option<String>,
pub is_primary_key: bool,
pub extra: Option<String>,
pub comment: Option<String>,
pub numeric_precision: Option<u32>,
pub numeric_scale: Option<u32>,
pub character_maximum_length: Option<u32>,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct ObjectSource {
pub name: String,
pub object_type: String,
pub schema: String,
pub source: String,
pub editable: bool,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct CompletionAssistantCandidate {
pub name: String,
pub kind: String,
pub database: Option<String>,
pub schema: Option<String>,
pub parent_schema: Option<String>,
pub parent_name: Option<String>,
pub comment: Option<String>,
pub data_type: Option<String>,
}
#[derive(Debug, Clone, Serialize, PartialEq, Eq)]
pub struct CompletionAssistantResponse {
pub candidates: Vec<CompletionAssistantCandidate>,
pub incomplete: bool,
pub fallback_used: bool,
}
#[derive(Debug, Clone, Default, Serialize, PartialEq)]
pub struct QueryResult {
pub columns: Vec<String>,
pub column_types: Vec<String>,
pub rows: Vec<Vec<Value>>,
pub affected_rows: i64,
pub execution_time_ms: i64,
pub truncated: bool,
}
#[derive(Debug, Clone, Default, Serialize, PartialEq)]
pub struct QueryPageResult {
pub columns: Vec<String>,
pub column_types: Vec<String>,
pub rows: Vec<Vec<Value>>,
pub affected_rows: i64,
pub execution_time_ms: i64,
pub truncated: bool,
pub session_id: Option<String>,
pub has_more: bool,
}
#[derive(Debug, Clone, Default, Serialize)]
#[serde(rename_all = "camelCase")]
pub struct DatabaseConnectionInfo {
pub product_name: Option<String>,
pub product_version: Option<String>,
pub current_database: Option<String>,
pub driver_name: Option<String>,
pub driver_version: Option<String>,
pub unquoted_identifier_case: Option<&'static str>,
pub quoted_identifier_case: Option<&'static str>,
}
#[derive(Debug, Clone, Default, Serialize)]
#[serde(rename_all = "camelCase")]
pub struct AgentConnectionInfo {
pub identifier_quote: String,
pub compatibility_mode: Option<String>,
pub database_info: Option<DatabaseConnectionInfo>,
}
pub const TDENGINE_DATA_TYPES: &[&str] = &[
"TIMESTAMP",
"BOOL",
"TINYINT",
"SMALLINT",
"INT",
"BIGINT",
"TINYINT UNSIGNED",
"SMALLINT UNSIGNED",
"INT UNSIGNED",
"BIGINT UNSIGNED",
"FLOAT",
"DOUBLE",
"BINARY",
"VARCHAR",
"NCHAR",
"JSON",
"VARBINARY",
"GEOMETRY",
"DECIMAL",
"BLOB",
"MEDIUMBLOB",
];