Plotly Studio Schema Browser

User Problem

When connecting to a database in Plotly Studio, users currently face a sluggish and inefficient exploration process. The system attempts to load all databases, schemas, and tables into a standard tabular view by default. This forces users to wait for the entire data structure to populate before they can begin browsing. Furthermore, once a user identifies a specific table, the system must trigger a round-trip request to the Large Language Model (LLM) to convert that exploration view into a functional table view, creating unnecessary latency and friction in the workflow.

What is it?

The Schema Browser is a dedicated navigational interface designed for data source exploration. Instead of repurposing a data table to show metadata, this feature retrieves the structural hierarchy of the connected data source—including databases, schemas, and tables—immediately upon connection. It presents this information in a conventional, nested tree-menu format located within the user interface.

What does it allow users to do?

The tree-menu interface provides a more intuitive and performant way to manage data connections:

• Instant Structural Visibility: Users can view the entire hierarchy of their data source at a glance without waiting for a tabular preview to render.

• Manual Navigation: Users can expand or collapse specific databases and schemas to locate the exact tables they need.

• Direct Table Selection: By interacting with the UI directly, users can select tables without requiring the LLM to generate intermediate views, significantly reducing wait times.

• Streamlined Workflow: It removes the technical overhead of "converting" views, allowing users to move from connection to data analysis in a single, fluid motion.