Does xsql support the Model Context Protocol (MCP)?

Yes, xsql includes an 'mcp server' command, making it compatible with the Model Context Protocol for enhanced AI tool integration.

Can I use xsql with private databases?

Yes, xsql supports SSH tunneling and configuration profiles, allowing it to connect to databases inside private VPCs or behind firewalls.

Which databases does xsql support?

Currently, xsql supports MySQL and PostgreSQL databases, including those requiring SSH tunnels for access.

How does xsql benefit AI agents like Claude?

It provides structured JSON output that is much easier for AI models to parse than standard table formatting, along with a 'spec' command to help the AI understand available tools.

Is xsql safe to use on production databases?

Yes, xsql is designed with safety first; it defaults to read-only mode and requires an explicit --unsafe-allow-write flag for any modifications.

xsql Cross-Database CLI

Name: xsql Cross-Database CLI
Author: zx06

byzx06

•

Database Management

Queries MySQL and PostgreSQL databases safely with read-only protection and structured JSON output for AI agents.

xsql is an AI-first command-line tool designed to bridge the gap between AI agents and relational databases. It provides a secure environment for inspecting data and schemas in MySQL and PostgreSQL, featuring mandatory read-only protection by default to prevent accidental data modification. With built-in support for SSH tunneling and standardized JSON output, it allows Claude and other AI models to explore databases, investigate logs, and analyze data distributions without the risk of damaging production environments.