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 axum::Json;
use dbx_core::text_export::{format_html, format_json, format_markdown, QueryResultTextExportData};
use serde::{Deserialize, Serialize};
use serde_json::Value;
use crate::error::AppError;
#[derive(Debug, Clone, Deserialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultTextExportRequest {
#[serde(default)]
pub title: Option<String>,
pub columns: Vec<String>,
pub rows: Vec<Vec<Value>>,
}
impl QueryResultTextExportRequest {
fn data(self) -> QueryResultTextExportData {
QueryResultTextExportData { title: self.title, columns: self.columns, rows: self.rows }
}
}
#[derive(Debug, Clone, Serialize)]
#[serde(rename_all = "camelCase")]
pub struct QueryResultTextExportResponse {
pub content: String,
}
pub async fn export_query_result_json(
Json(req): Json<QueryResultTextExportRequest>,
) -> Result<Json<QueryResultTextExportResponse>, AppError> {
let content = format_json(&req.data()).map_err(AppError::from)?;
Ok(Json(QueryResultTextExportResponse { content }))
}
pub async fn export_query_result_markdown(
Json(req): Json<QueryResultTextExportRequest>,
) -> Json<QueryResultTextExportResponse> {
Json(QueryResultTextExportResponse { content: format_markdown(&req.data()) })
}
pub async fn export_query_result_html(
Json(req): Json<QueryResultTextExportRequest>,
) -> Json<QueryResultTextExportResponse> {
Json(QueryResultTextExportResponse { content: format_html(&req.data()) })
}