sql-talk

library0.1.43jsnpmunverified

SQL Talk is an MCP server (v0.1.43) that converts natural language to SQL with safety guards and SSH tunnel support. It integrates with Cursor editor for Japanese-language database operations. Key differentiators: read-only query enforcement, PII masking, query result limits, and audit logging. Supports MySQL 8.0+ and PostgreSQL 12+. Released under MIT License, active development with frequent updates.

database

npm install sql-talk

package ↗

INSTALL

IMPORT

SIG · SQL-TALK

sql-talk

databasejavascriptv0.1.43

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

mcp server

✓ Add to Cursor MCP config: { "command": "npx", "args": ["sql-talk@latest"] }

✗ Installing globally with npm install -g sql-talk

Run via npx to always use latest version; global install may cause version conflicts.

configuration

✓ Create sql-talk.config.yml in project root

✗ Using JSON config file or environment variables only

Config format is YAML; sample file is sql-talk.config.yml.sample.

SSH tunnel

✓ Define ssh_tunnels section in config YAML with ssh_private_key_path or ssh_password

✗ Omitting local_port or remote_host/remote_port

SSH tunnel auto-starts if auto_start: true; ensure local_port is unique.

Configures SQL Talk MCP server with MySQL connection, read-only safety limits, and PII masking for use with Cursor editor.

// sql-talk.config.yml engine: mysql connections: read_only: host: localhost port: 3306 user: user password: pass database: mydb ddl_comment: host: localhost port: 3306 user: user password: pass database: mydb limits: default_limit: 100 max_limit: 1000 pii: masking: enabled: true strategy: partial // In Cursor MCP config (~/.cursor/mcp.json): { "mcpServers": { "sql-talk": { "command": "npx", "args": ["sql-talk@latest"] } } }

Debug

Known issues

breakingPassword field changed from 'password' to 'password' in connections - ensure correct key name.

fix

Use 'password' (not 'pass' or 'pwd').

affects: >=0.1.0

deprecatedDeprecated config field 'masking_enabled' use 'masking.enabled' instead.

fix

Update to nested format: masking: { enabled: true }.

affects: >=0.1.20

gotchaWhen using SSH tunnels, local_port must match database host port in config.

fix

Set database host to localhost and port to the same local_port value defined in ssh_tunnels.

affects: >=0.1.0

gotchaIf both 'database' and 'databases' are omitted, connection fails.

fix

Specify either 'database' (single) or 'databases' (list) under each connection.

affects: >=0.1.0

Errors

Common errors & fixes

Error: connect ECONNREFUSED ::1:3306

MySQL/PostgreSQL not running or not accessible on localhost:3306

fix

Start database service or check host/port in sql-talk.config.yml.

Error: MCP server 'sql-talk' not found in Cursor

Cursor MCP configuration missing or incorrect JSON syntax

fix

Check ~/.cursor/mcp.json for correct JSON structure and restart Cursor.

Error: sql-talk.config.yml not found

Config file missing from project root or wrong working directory

fix

Ensure sql-talk.config.yml exists in the project root or set cwd appropriately.

Error: SSH tunnel failed: Error: All configured authentication methods failed

Invalid SSH credentials or private key path

fix

Verify ssh_user, ssh_private_key_path or ssh_password in tunnel config.

Error: PII masking requires 'strategy' to be one of: partial, full, none

Invalid or missing strategy in PII config

fix

Set pii.masking.strategy to 'partial', 'full', or 'none'.

Upgrade

Version history

0.1.43latest on npm

Audit

Dependencies

noderequiredRequires Node.js >= 20.0.0

Agent activity

13 hits · last 30 days

node