What formats can I export my data in?

You can export query results in several formats including standard ASCII tables, CSV, JSON, and Markdown.

Where are my database credentials stored?

Credentials are stored locally on your machine in a credentials.json file located in either your project directory or user home directory under the .claude/data-analyze folder.

Which database engines are supported by this skill?

The Unified SQL skill currently supports PostgreSQL, MySQL (and MariaDB), and SQLite databases.

Can I join data from two different databases in one query?

Yes, this skill supports federated queries, allowing you to perform joins between tables residing in different database systems (e.g., joining a PostgreSQL table with a SQLite table).

Is it safe to use this with production databases?

Yes, the skill runs in read-only mode by default to prevent accidental data modification. Write operations are blocked unless you explicitly use the --allow-writes flag.

Unified SQL Data Analyst

Name: Unified SQL Data Analyst
Author: meomeocoj

bymeomeocoj

0•

Database Management

Queries and joins data across PostgreSQL, MySQL, and SQLite databases using a unified SQL engine for advanced data exploration.

The Unified SQL skill enables Claude to interact with multiple database types simultaneously by leveraging DuckDB as a federated query engine. It allows users to perform cross-database joins, explore schemas, and sample data across PostgreSQL, MySQL, and SQLite without switching tools. Designed for developers and analysts, it includes robust security features like read-only defaults and credential masking, while providing flexible export options for query results including CSV, JSON, and Markdown. This skill is ideal for data validation, complex reporting, and rapid database discovery within the Claude Code environment.

Key Features

01Federated queries to join tables across different database engines

02Multi-format data export including CSV, JSON, and Markdown tables

03Read-only security mode by default with optional write permission overrides

040 GitHub stars

05Automated schema exploration, table descriptions, and data sampling

06Support for PostgreSQL, MySQL, and SQLite through DuckDB extensions

Use Cases

01Exporting specific query results to local files for documentation or external reporting

02Joining production PostgreSQL user data with analytical metrics stored in MySQL

03Exploring unfamiliar database schemas and generating data quality summaries

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add meomeocoj/cc-plugins unified-sql

For use in Claude.ai and ChatGPT

Download Skill