CFTPay DB Explorer

CFTPay database explorer for Cursor — connect to preset or custom MySQL servers, browse schema, and run SQL.

Features

• Connect with host, port, username, password (optional database)
• Preset servers shipped in presets/connections.json (listed under Connect)
• Saved connections (passwords stored in Cursor Secret Storage)
• Lazy-loaded schema tree: databases → tables → columns
• SQL query editor with result grid
• Connection pooling via mysql2 for speed

Preset servers

Edit presets/connections.json before packaging to ship team/default servers with the VSIX. Do not put passwords in this file — Open VSX (and good practice) reject published secrets.

[
  {
    "id": "preset-qaperfcft",
    "name": "qaperfcft",
    "host": "qaperfcft-aurora-mysql.np.prth.cloud",
    "port": 3306,
    "user": "fx_dev_reinvent"
  }
]

These appear under Servers below the Connect button. Click a server to expand:

1. Connect to server — prompts for password on first connect, then stores it in Cursor Secret Storage
2. Create new SQL file — saved under the extension’s local storage for that server
3. Open existing SQL files — lists local .sql files for that server

SQL files are stored on disk at Cursor’s global storage path under the extension id.

Install (local development)

cd /Users/pushpitbatra/Cursor/mysql-explorer
npm install
npm run compile

Option A — Launch from Cursor

1. Open this folder in Cursor
2. Press F5
3. Click the CFTPay DB icon in the Activity Bar

Option B — Install as VSIX

npx @vscode/vsce package --allow-missing-repository

Then in Cursor: Extensions → … → Install from VSIX…

Usage

1. Open CFTPay DB from the Activity Bar
2. Expand a preset server or enter connection details → Connect
3. Browse schema / run SQL as needed

Settings

Security

• Passwords are never written to plain settings files
• Saved passwords use VS Code / Cursor SecretStorage
• System schemas (mysql, sys, information_schema, performance_schema) are hidden from the tree