Design and Manage ThoughtSpot Databases with DbSchema
Build a clearer workflow for ThoughtSpot: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.
DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.
Download DbSchema See ThoughtSpot Features Download ThoughtSpot JDBC Driver
What happens after you download?
Get to your first ThoughtSpot schema diagram in minutes. No account, no credit card.
Install in minutes
Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.
Connect to ThoughtSpot or open a sample
Reverse engineer an existing ThoughtSpot database or open a sample model to explore tables, relationships, and indexes.
Design, document, and deploy
Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.
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.
Download DbSchema Free See ThoughtSpot Features
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