MAXZOFT Studio
A Postman-class API client and a Navicat-style database manager — together in one VS Code extension.
Design & test APIs, browse & query databases (MySQL · PostgreSQL · MSSQL · SQLite), all from a single Activity-Bar panel without leaving your editor.
✨ Why MAXZOFT Studio?
One unified panel, two complete tools. A top toolbar switches between API, Database, Account, and Settings — every studio opens in its own editor tab, so you can keep an API request, a SQL query, and a table designer side by side.
🚀 Features
🧪 API Studio
- Multi-tab request workbench — every request keeps its own response.
- All HTTP methods, query params, headers, cookies, bodies (JSON · XML · form-data · text · raw).
- Auth helpers (Bearer · Basic · API key), pre-request scripts, and a built-in Tests runner.
- One-click Beautify; rich CodeMirror response viewer (highlighting, HTML preview, headers, timing & size).
- Nested collections → folders → requests with drag & drop, search, and import from Postman / Insomnia / OpenAPI.
- Environments with variable substitution (
{{baseUrl}}, {{token}}).
- (Optional account) cloud sync, team workspaces, role-based access, and realtime collaboration.
- Generate OpenAPI 3.1 docs, cURL & SDK snippets, and expose collections as MCP tools for AI agents.
🗄️ Database Studio
- Connect to MySQL, PostgreSQL, MSSQL, and SQLite — multiple connections live at once.
- Add/Edit a connection by Form or JSON (toggle in one editor), with show/hide password and live Test.
- Organize connections into folders — create, rename, delete, and drag & drop to reorder or regroup.
- Schema tree — Tables / Views grouped, expand a table to see its columns & keys, with a filter box.
- Query Studio (one per connection) — CodeMirror SQL editor with autocomplete, multi-tab, Run / Run Selected, a centered Fetching… progress modal with elapsed time, and multi-statement results (
Result (1), Result (2)).
- Editable result grid (Navicat-style) — double-click a cell to edit, add/delete rows, and save back to any table.
- Double-click a table/view to query it (tab named after the object); right-click for Design Table, Edit View (ALTER), View Columns, Copy Name, and Drop (with confirmation + auto-reload).
- Table Designer — create/alter tables visually across all four dialects.
- Server Monitor — live process list (
SHOW PROCESSLIST / pg_stat_activity / sys.dm_exec_*) with auto-refresh, filter, multi-select, and Kill process.
- AI assistant — ask in plain language and get grounded SQL, powered by Ollama + Qdrant RAG over your indexed schema (with thinking time & token usage).
👤 Account & ⚙️ Settings
- Sign in (email/password or Google) right in the Account panel to enable cloud sync & teams.
- AI (Ollama/Qdrant) and database/API settings in one place.
🏁 Getting started
- Install the extension and click the MAXZOFT Studio icon in the Activity Bar.
- API → Open API Studio to send requests, or Import a Postman/Insomnia/OpenAPI collection.
- Database → Add Connection (Form or JSON), then double-click a connection to connect and open its Query Studio.
- Double-click any table/view to query it; double-click a cell to edit; right-click for designer/drop/columns.
⚙️ Settings
| Setting |
Default |
Description |
maxzoftApiStudio.apiBaseUrl |
http://127.0.0.1:8787 |
Base URL of the MAXZOFT backend for sync/teams. |
maxzoftApiStudio.docsPortalUrl |
https://maxzoft-docs.pages.dev |
Public docs portal for published API docs. |
maxzoftApiStudio.requestTimeoutMs |
30000 |
HTTP request timeout (ms). |
dbstudio.defaultLimit |
100 |
Row limit for Select Top N Rows. |
dbstudio.queryTimeout |
30000 |
SQL query timeout (ms). |
dbstudio.gridPageSize |
200 |
Rows per page in the result grid. |
dbstudio.ai.* |
— |
Ollama / Qdrant URLs & models for the AI assistant. |
🗃️ Requirements
- Database drivers (
mysql2, pg, mssql, better-sqlite3) ship with the extension.
- The AI assistant is optional and needs locally-running Ollama and Qdrant.
- Cloud sync / teams are optional and require a MAXZOFT account.
🔒 Privacy
API requests and database queries run locally from your machine. Database passwords are stored in VS Code SecretStorage. Cloud sync is opt-in — nothing leaves your device until you sign in and sync.
| |
