How do I query multiple databases and environments in the same SQL statement?
Query tables from other projects or environments in the same statement, even across PostgreSQL and MySQL. You do not need a DB Link on the server.
Read the articleGuides
Tutorials that walk through database work in Kerry Studio. Each article starts from a common question and shows the full flow in the app.
-
-
How do I use MCP with a database without exposing credentials?
Connect your AI assistant to the databases configured in Kerry Studio without sharing passwords, SSH keys, or certificates with the model. Access is read-only by default, and you decide which projects and environments the assistant can reach.
Read the article -
How do I reuse SQL values across staging and production without rewriting the query?
Change limits, filters, and test values between Staging and Production without rewriting the query. The values live in the Variables panel and follow the tab’s environment.
Read the article -
How do I visualize GIS and PostGIS data from a SQL query?
See the query’s geometry on a map beside the grid, without copying the text into another program. You can draw a shape and paste the polygon back into the SQL.
Read the article