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

データベース管理

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.

主な機能

Federated queries to join tables across different database engines
Multi-format data export including CSV, JSON, and Markdown tables
Read-only security mode by default with optional write permission overrides
0 GitHub stars
Automated schema exploration, table descriptions, and data sampling
Support for PostgreSQL, MySQL, and SQLite through DuckDB extensions

ユースケース

Exporting specific query results to local files for documentation or external reporting
Joining production PostgreSQL user data with analytical metrics stored in MySQL
Exploring unfamiliar database schemas and generating data quality summaries

概要

主な機能

Federated queries to join tables across different database engines
Multi-format data export including CSV, JSON, and Markdown tables
Read-only security mode by default with optional write permission overrides
0 GitHub stars
Automated schema exploration, table descriptions, and data sampling
Support for PostgreSQL, MySQL, and SQLite through DuckDB extensions

ユースケース

Exporting specific query results to local files for documentation or external reporting
Joining production PostgreSQL user data with analytical metrics stored in MySQL
Exploring unfamiliar database schemas and generating data quality summaries