Zaturn
Zaturn 让您使用 AI 聊天分析您的数据;而无需您编写 SQL/Python 代码或摆弄美观(但令人不知所措)的仪表板。
您可以将 Zaturn MCP 添加到 Claude Desktop(或任何 MCP 客户端),连接您的数据源,使用自然语言提问,并通过可视化获得即时洞察。借助 Zaturn,您的 AI 可以自动理解您拥有的数据类型,进行查询,并以连贯的叙述方式为您提供有用的指导。您可以提出具体的问题,例如“谁是我们最有价值的客户?”,或者让 AI 通过提出“这是我们拥有的所有数据,请为下一季度提供一些建议”之类的问题来探索您的数据。
但是我可以将我的数据上传到 ChatGPT 并让它进行分析,对吗?
是的,但 ChatGPT 对 CSV 文件/电子表格的上传大小限制约为 50MB,而且上传也需要时间。此外,它无法直接从您的 MySQL 或 PostgreSQL 服务器读取数据。Zaturn 可以克服所有这些限制,而无需将您的数据移动到任何地方。它只需为您的 AI 配备 SQL 和可视化功能,即可让 AI 直接查询您的数据、获取结果、进行处理并为您提供即时洞察。使用 Zaturn,AI 无需处理您的完整数据集并将其保存在内存中即可回答您关于数据的问题。
Related MCP server: Superset MCP Server
Zaturn 行动
https://github.com/user-attachments/assets/d42dc433-e5ec-4b3e-bef0-5cfc097396ab
特征:
多个数据源
Zaturn 目前可以连接以下数据源:
SQL 数据库:PostgreSQL、SQLite、DuckDB、MySQL、ClickHouse
文件:CSV、Parquet
正在添加更多数据源的连接器。
可视化
除了提供表格和文本摘要外,Zaturn 还可以生成以下图像可视化
散点图和线图
直方图
条形图和箱线图
条形图
注意:仅当您的 MCP 客户端支持图像渲染(例如 Claude Desktop)时才会显示视觉效果
如果您的 MCP 客户端不支持图像(例如 Cursor),请在 MCP 配置中添加
--noimg参数。这样,绘图将以文件形式存储,并返回文件位置。您可以使用文件浏览器查看绘图。
正在添加更多可视化功能。
安装和设置
uv tool install zaturn添加到 MCP 配置,包含数据源:
"mcpServers": {
"zaturn": {
"command": "zaturn_mcp",
"args": [
"postgresql://username:password@host:port/dbname",
"mysql+pymysql://username:password@host:3306/dbname",
"sqlite:////full/path/to/sample_dbs/northwind.db",
"/full/path/to/sample_dbs/titanic.parquet",
"/full/path/to/sample_dbs/ny_aq.csv",
"/full/path/to/sample_dbs/duckdb_sample.duckdb"
]
},
}或者将sources.txt添加到 Zaturn 配置目录:
postgresql://username:password@host:port/dbname
mysql+pymysql://username:password@host:3306/dbname
clickhouse://username:password@host:port/dbname
sqlite:////full/path/to/sample_dbs/northwind.db
/full/path/to/sample_dbs/titanic.parquet
/full/path/to/sample_dbs/ny_aq.csv
/full/path/to/sample_dbs/duckdb_sample.duckdb该文件在 Linux/MacOS 上需要位于~/.config/zaturn/sources.txt ,在 Windows 上需要位于%APPDATA%\zaturn\sources.txt 。
如果您的 MCP 客户端不支持图像渲染,请添加--noimg参数:
...
"args": [
"--noimg",
"mysql+pymysql://username:password@host:3306/dbname",
...如果您的 LLM/IDE 允许您执行以下操作,请设置系统提示:
You are a helpful data analysis assistant. Use only the tool provided data sources to process user inputs. Do not use external sources or your own knowledge base.提出问题并观看魔术:
User: List the top 5 customers by revenue for Northwind
AI:
The top 5 customers by revenue for Northwind are:
1. B's Beverages with a revenue of $6,154,115.34
2. Hungry Coyote Import Store** with a revenue of $5,698,023.67
3. Rancho grande with a revenue of $5,559,110.08
4. Gourmet Lanchonetes with a revenue of $5,552,597.90
5. Ana Trujillo Emparedados y helados with a revenue of $5,534,356.6路线图
支持更多数据源类型
更多数据可视化
预测分析和预报,例如:
Based on the revenue of the last 3 months, forecast next month's revenue.生成演示文稿和 PDF
Manager:
I need a presentation to show the boss. Can you do it by EOD?
Analyst:
EOD?! Are you still in the 2010s?
I can get it done right now. Actually, you can do it right now.
You know what? The boss can do it right now.原生笔记本界面
帮助和反馈
支持该项目
如果您发现 Zaturn 有用,请通过以下方式支持该项目:
主演项目
传播信息
您的支持将使我能够将更多的时间投入到 Zaturn 中。
示例数据集
Sarah Taha 和 PokéAPI 编制的 pokemon 数据集已纳入CC BY-NC-SA 4.0许可,用于演示目的。
星史
Available Tools
12 toolsbar_plotA
Run query against specified source and make a bar plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), x (required), y (required), +2 more.
box_plotA
Run query against specified source and make a box plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), x (required), y (required), +1 more.
density_heatmapA
Run query against specified source and make a 2d-histogram aka. Density Heatmap using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), column_x (required), column_y (required), +2 more.
describe_tableB
Lists columns and their types in the specified table of specified data source.
Inputs: source_id (required), table_name (required). Returns: result
histogramB
Run query against specified source and make a histogram using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), column (required), color, +1 more.
line_plotC
Run query against specified source and make a line plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), x (required), y (required), +1 more.
list_data_sourcesA
List all available data sources. Returns a list of unique source_ids to be used for other queries. Source type is included in the source_id string. While drafting SQL queries use appropriate syntax as per source type.
Inputs: no named parameters. Returns: result
polar_lineA
Run query against specified source and make a polar line plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), r (required), theta (required), +1 more.
polar_scatterB
Run query against specified source and make a polar scatter plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), r (required), theta (required), +1 more.
run_queryA
Run query against specified source For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name for csv sources. Use 'PARQUET' as the table name for parquet sources.
This will return a dataframe with the results.
Inputs: source_id (required), query (required). Returns: result
scatter_plotC
Run query against specified source and make a scatter plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), x (required), y (required), +1 more.
strip_plotB
Run query against specified source and make a strip plot using result For both csv and parquet sources, use DuckDB SQL syntax Use 'CSV' as the table name in the SQL query for csv sources. Use 'PARQUET' as the table name in the SQL query for parquet sources.
This will return an image of the plot
Inputs: source_id (required), query (required), x (required), y (required), +1 more.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 12 tools
Every tool has a clearly distinct purpose: 10 visualization tools each create different plot types (bar, box, scatter, etc.), 'run_query' returns raw data, 'list_data_sources' enumerates sources, and 'describe_table' provides schema information. There is no functional overlap between tools - an agent can easily select the right tool for each task.
All tools follow a consistent snake_case naming convention with clear verb_noun patterns: visualization tools use plot_type names (bar_plot, scatter_plot), while utility tools use action_object patterns (run_query, list_data_sources, describe_table). The naming is perfectly predictable and follows a single convention throughout.
12 tools is well-scoped for a data visualization and query server. The count includes comprehensive visualization coverage (10 plot types), core data operations (run_query), and metadata utilities (list_data_sources, describe_table). Each tool earns its place without redundancy or bloat.
The toolset provides excellent coverage for data exploration and visualization: query execution, schema inspection, source enumeration, and multiple plot types. Minor gaps include lack of data modification tools (update/delete) and advanced analytics functions, but these may be outside the server's intended scope as a visualization-focused tool.
Maintenance
Related MCP Connectors
MCP server for querying and analyzing data from ad platforms, analytics tools, and spreadsheets
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceAn MCP (Model Context Protocol) server that exposes natural language to SQL functionality, allowing any MCP-compatible client to convert plain English questions into SQL queries for database interaction using AI.3MIT
- AlicenseNot gradedqualityDmaintenanceAn MCP server for Apache Superset that enables AI models to manage dashboards, create charts with auto-detection, and execute SQL queries programmatically. It utilizes stateless HTTP transport to ensure compatibility with integration tools like Open WebUI.MIT
- FlicenseNot gradedqualityBmaintenanceAn MCP server that exposes relational databases (PostgreSQL/MySQL) to AI agents with natural language to SQL query support.19-
- AlicenseNot gradedqualityDmaintenanceAn MCP server that enables SQL analytics on DuckDB and MotherDuck databases, allowing AI assistants and IDEs to query and analyze data.MIT