Test your API, your UI, and your database in one tool

When you're debugging a bug, you usually need three windows open: your API client, your browser, and a database GUI. You send the request, watch the response, check if the database updated correctly, then reload your UI to see if the UI reflects the change. It's a workflow loop that every developer knows. Rostyman is the first tool designed to close that loop — API testing, browser automation, and a database client, all in one window.

Why three separate tools slow you down

Context-switching between apps has a cost that's easy to underestimate. Every switch resets your mental stack. You tab out of your API client, wait for the database GUI to wake up, navigate back to the table you were looking at, then switch to the browser to run the test — and now you've forgotten which assertion failed. Integrated tooling isn't just convenient. It's a cognitive advantage.

There's also the practical issue of shared state. An API test that sets an environment variable should be visible to the database query you run next. A browser test that fills a form should be validated against the database row it creates. When these tools are separate applications, sharing state requires manual copy-paste. In Rostyman, it's native.

What API testing looks like today

Rostyman's API layer is fully built and shipping. Eight protocols: HTTP/REST, GraphQL, gRPC, WebSocket, Socket.IO, MQTT, SSE, and MCP. Every protocol supports auth, scripts, history, environments, and collections. The scripting API is rm.* — rm.environment.get(), rm.test(), rm.expect() — familiar if you've used any modern API client, but running entirely locally with no cloud execution.

The visual workflow editor lets you chain requests into multi-step flows — auth token fetch, conditional branching, transform steps, retry logic — without writing orchestration code. The AI assistant (OpenAI, Anthropic, or local Ollama) can generate requests from plain English, explain responses, and write test assertions.

The database layer (shipped)

The database client is now part of Rostyman. Eight drivers ship out of the box: PostgreSQL, MySQL, MariaDB, SQLite, Microsoft SQL Server, MongoDB, Redis, and CockroachDB. The query editor is Monaco with schema-aware autocomplete and SQL hover tooltips. Browse mode gives paginated rows with inline cell editing. Every connection gets an EXPLAIN visualizer, an ER diagram (with MiniMap, Zoom-to-Area, Fullscreen mode, and a true vector PDF export), and a Schema Diff that emits migration SQL.

The key feature that sets it apart from standalone tools like TablePlus or DBeaver is DB Verify: every HTTP request gets a DB Verify tab where you write a SQL assertion that runs the moment the response arrives. Send a POST /users and Rostyman immediately checks that SELECT count(*) FROM users WHERE email = … went up by one. No tab-switching, no copy-paste — assertion next to assertion.

The AI assistant is wired into the same layer. Ask in plain English, get runnable SQL in your dialect. One click runs a schema audit for missing indexes, missing constraints, and type mismatches. Another click generates a stored procedure from a description. Generate API Collection takes any subset of tables and writes a complete REST collection (List / Get / Create / Update / Delete) into your sidebar — wired to {{baseUrl}}, ready to send.

The browser layer (now shipped)

The browser automation layer uses embedded Chromium via the Chrome DevTools Protocol — no Playwright or Puppeteer config files required. 44 step types, visual regression testing, WCAG accessibility audits, performance scoring, and AI test generation are all available today. The assertDB step lets you bind a database connection to a browser test and validate that a UI action produced the expected database change — closing the loop between the three layers entirely. The browser layer ships as beta: it's reliable on simple sites and localhost apps, with rough edges on complex SPAs, OAuth flows, and third-party sites while we harden it.

Today

All three layers — API, database, and browser (in beta) — are available now, free, no account required. With the workflow editor and the AI assistant alongside them, Rostyman replaces most of the toolchain a developer reaches for in a typical debugging loop: one window for the request, the database state, and the UI all at once.