Automatic schema import

Connect your SQL database and automate schema import in seconds

Exploring manually a database structure may be slow, error-prone, and often incomplete.
SQLInfo removes this friction by automatically connecting your SQL database and importing your entire schema in just a few seconds.

Once connected, SQLInfo analyzes your database structure and builds a complete, accurate representation

Full schema analysis

SQLInfo performs a complete analysis of your database schema by directly reading its structural metadata. Every core component of your database architecture is extracted and structured to provide a precise and reliable representation in SQLInfo platform.

Database structure coverage

SQLInfo automates schema import including all structural elements and constraints that define how your database is built and how its objects interact:

  • Tables and Columns
    All tables within the database are identified, along with their associated columns and schema hierarchy.
  • Data Types and Nullability
    Each column’s data type (e.g., INT, VARCHAR, DATE, BOOLEAN, etc.) is retrieved, including length, precision, scale, and whether the column allows NULL values.
  • Primary Keys
    Single-column and composite primary keys are detected to clearly define record uniqueness and entity identity.
  • Foreign Keys and Relationships
    All referential constraints are analyzed, mapping relationships between tables and identifies parent-child dependencies.
  • Indexes
    Index definitions are extracted, including unique, composite, clustered, and non-clustered indexes, helping to understand performance and access patterns.
  • Constraints
    Check constraints, unique constraints, default values, and other integrity rules are identified to reflect the data validation logic enforced at the database level.
  • Views
    Logical views and their definitions are included, capturing abstraction layers and reusable query logic.
  • Functions, Procedures, and Triggers
    Database-level logic such as user-defined functions, stored procedures, and triggers is analyzed to provide visibility into embedded business rules and automated behaviors.

Always Up to Date

Database schemas continuously evolve. Tables are added, columns are updated, indexes are optimized, and constraints change as applications grow and requirements shift. Maintaining an accurate view of your database structure can quickly become difficult and error-prone.

With SQLInfo, your schema representation always stays aligned with the real structure of your database, ensuring consistency between development, staging, and production environments.

Continuous structural accuracy

  • Always up-to-date schema visibility
    The structure you access reflects the current state of your database.
  • No manual tracking of schema changes
    Structural updates do not require additional effort on your side.
  • No discrepancies between environments
    Avoid mismatches between what is deployed and what is understood.
  • Reliable production alignment
    Your schema overview mirrors what actually exists in your live systems.

What you get:

  • Immediate access to your full database structure
    Explore tables, relationships, constraints, and database logic without delay.
  • A clear and structured overview from day one
    Quickly understand how entities are organized and interconnected.
  • A continuously aligned schema view
    Structural changes are reflected as they occur.
  • No maintenance overhead
    Focus on development and analysis instead of tracking schema updates.
  • Zero setup complexity
    Connect and gain complete structural insight without configuration burden.