Can I perform SQL queries directly on my local data files?

Yes, Reparatio allows you to execute SQL queries (e.g., `SELECT`, `WHERE`, `GROUP BY`, `ORDER BY`, and aggregations) directly against your local data files, treating them as tables for powerful data manipulation.

What file formats does Reparatio support?

Reparatio supports over 20 data and archive formats, including CSV, Excel (.xlsx, .xls), JSON, Parquet, SQLite, GeoJSON, YAML, XML, HTML, Markdown, and compressed files like gzip and zip.

What is Reparatio and what does it do?

Reparatio is an AI assistant-powered tool that processes and transforms local data files directly on your machine. It allows you to inspect, convert, merge, append, and run SQL queries against various data formats.

Is an API key always required to use Reparatio?

No. The `inspect_file` function works without an API key. However, advanced operations like converting, merging, appending, and querying files require a Professional plan API key from reparatio.app.

How does Reparatio integrate with AI assistants and IDEs?

Reparatio runs as a local MCP (Multi-Client Protocol) server, enabling direct tool call integration with popular AI assistant clients and IDEs like Claude Desktop, Cursor, VS Code (Copilot/Continue), Open WebUI, and Zed.

Reparatio: AI Data Processing, Conversion & SQL for Local Files

Reparatio is an AI assistant tool that acts as an MCP server, enabling inspection, conversion, merging, appending, and querying of local data files. It integrates seamlessly with various AI clients and LLMs, such as Claude Desktop, Cursor, VS Code GitHub Copilot, Continue, Zed, and Open WebUI, allowing users to manipulate a wide array of file formats including CSV, Excel, JSON, Parquet, SQLite, and more using natural language prompts. The server processes files locally, sending only metadata and options to the Reparatio API for advanced operations, ensuring binary data remains on your machine.

Características Principales

01Inspect file encoding, schema, and data previews without an API key.

02Merge or append multiple local data files using SQL-style joins (left, right, outer, inner) or vertical stacking.

03Supports a wide array of input formats including compressed files (gzip, bzip2, zstd, zip), and specialized formats like GeoJSON, YAML, BSON, SRT, VTT, HTML, Markdown, XML, SQL dumps, and PDF (text layer).

040 GitHub stars

05Convert files between over 20 different data and archive formats (e.g., CSV, Excel, JSON, Parquet, SQLite).

06Execute SQL queries directly against local files, treating them as tables, with support for `SELECT`, `WHERE`, `GROUP BY`, `ORDER BY`, and aggregations.

Casos de Uso

01Automate data cleaning and transformation tasks by issuing natural language commands to an AI assistant.

02Integrate complex local file operations like format conversion, merging, and appending into AI-powered development and analysis workflows.

03Analyze and query diverse local datasets (e.g., CSV, Parquet, SQLite) using SQL directly through an AI assistant, getting results in a specified output format.