Design and Manage ThoughtSpot Databases Visually with DbSchema

DbSchema lets you design, manage, and document ThoughtSpot databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the ThoughtSpot database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

Download DbSchema Download ThoughtSpot JDBC Driver

Schema Visualization for ThoughtSpot's Falcon Engine

ThoughtSpot's Falcon in-memory database stores data in a proprietary columnar engine optimized for search-driven analytics. While ThoughtSpot provides a web-based modeling interface for worksheets and tables, data engineers working on ingestion pipelines or schema design sometimes need a SQL-level view of the data model. DbSchema connects to ThoughtSpot via the JDBC driver, discovers the available Falcon tables, and renders them as an entity-relationship diagram for data engineers managing the deployment.

ER Diagrams for ThoughtSpot Falcon Tables

DbSchema reads the ThoughtSpot schema through the JDBC connection and displays Falcon tables, columns, and join relationships on a visual canvas. This structural view complements the ThoughtSpot web modeling interface, providing a developer-oriented schema perspective for engineers maintaining the data layer.

Visual Query Builder for ThoughtSpot Data

DbSchema's query builder generates SQL-compatible queries against ThoughtSpot tables without requiring knowledge of TQL syntax. Select tables, choose columns, and apply filters from a graphical interface to quickly inspect data loaded into the Falcon engine for validation or debugging purposes.

Schema Documentation for ThoughtSpot Data Engineers

DbSchema generates HTML documentation from the ThoughtSpot schema, capturing table structures, column types, and join definitions. This documentation is useful for data engineering teams maintaining large ThoughtSpot deployments where schema changes need to be tracked alongside worksheet and pinboard configurations.

Connecting DbSchema to ThoughtSpot

The ThoughtSpot JDBC driver connects to the Falcon database on the port configured in your ThoughtSpot instance (commonly 12345 for the JDBC endpoint). The JDBC URL format is: jdbc:thoughtspot://host:12345/. The JDBC driver class is com.thoughtspot.jdbc.Driver. Download the ThoughtSpot JDBC driver from the ThoughtSpot developer portal and add it via DbSchema's driver manager under Connections > Manage Drivers. Authenticate using your ThoughtSpot username and password.

Why DbSchema for ThoughtSpot

• Visualize ThoughtSpot Falcon table schemas and join relationships as ER diagrams
• Run TQL-compatible queries from a desktop client without the ThoughtSpot web interface
• Generate documentation for ThoughtSpot schemas to support data engineering workflows
• Inspect ThoughtSpot table data with the query builder without writing raw SQL
• Compare ThoughtSpot schema versions between development and production deployments