Common questions about SQLPro Studio, databases, and SQL.
SQLPro Studio is a native database client for macOS, iOS, and Windows. It lets you connect to, query, and manage MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Oracle, and Snowflake databases from a single app.
SQLPro Studio supports MySQL, MariaDB, PostgreSQL, Microsoft SQL Server (2005 and above), SQLite, Oracle (8i and above), Snowflake, and Amazon Redshift.
SQLPro Studio is available on macOS, iOS/iPadOS, and Windows.
Yes. SQLPro Studio is built with Swift and Objective-C on macOS and iOS. It is not a Java or Electron app, so it launches instantly and uses minimal system resources.
No. SQLPro Studio is 100% native and does not require Java, the JVM, or any other runtime to be installed.
Yes. SQLPro Studio supports SSH tunneling for all supported database types, allowing you to securely connect to remote databases through an SSH server.
Yes. SQLPro Studio works with cloud-hosted databases including Amazon RDS, Azure SQL Database, Google Cloud SQL, Heroku Postgres, DigitalOcean Managed Databases, and Snowflake.
Yes. SQLPro Studio supports dark mode on macOS, iOS, and Windows, and will follow your system appearance settings.
Yes. SQLPro Studio can import data from CSV, JSON, and SQL files directly into your database tables.
Yes. SQLPro Studio can export query results and table data to CSV, JSON, and XML formats.
Yes. The query editor includes syntax highlighting and autocomplete for table names, column names, and SQL keywords across all supported databases.
Yes. SQLPro Studio supports multiple result sets, so you can execute several queries and see all results displayed simultaneously.
SQLPro Studio offers monthly subscriptions, yearly subscriptions, and a one-time lifetime license. Visit the pricing page at sqlprostudio.com/price.php for current prices.
Yes. SQLPro Studio offers a free trial so you can evaluate the app before purchasing. Download it from sqlprostudio.com/download.php.
Yes. SQLPro Studio offers a true lifetime license with updates forever. This is a one-time purchase that includes all future updates at no additional cost.
Yes. SQLPro Studio offers a free one-year license for students with a valid student email address.
No. SQLPro Studio subscriptions include access on macOS, iOS, and Windows. You do not need to pay separately for the iOS app.
Both are popular open-source relational databases. MySQL is known for ease of use and speed with simple queries. PostgreSQL supports more advanced features like JSONB, window functions, CTEs, and custom types. SQLPro Studio supports both.
SQL Server is developed by Microsoft and is common in enterprise Windows environments. MySQL is open-source and popular for web applications. They use different SQL dialects — T-SQL for SQL Server and MySQL SQL. SQLPro Studio supports both.
SQLite is a lightweight, file-based database engine that requires no server. It is embedded in mobile apps, desktop applications, and browsers. SQLPro Studio can open and manage SQLite database files directly.
Snowflake is a cloud-native data warehouse platform. It runs entirely in the cloud and supports SQL queries on large-scale analytics data. SQLPro Studio can connect to Snowflake and run queries against your data warehouse.
A database index is a data structure that speeds up row lookups. It works like a book index — instead of scanning every row, the database uses the index to jump directly to matching rows. Indexes speed up reads but slow down writes slightly.
A foreign key is a column that references the primary key of another table. It enforces referential integrity — ensuring that relationships between tables remain valid. For example, an order's customer_id must match an existing customer.
A JOIN combines rows from two or more tables based on a related column. INNER JOIN returns matching rows from both tables. LEFT JOIN returns all rows from the left table plus matching rows from the right. FULL OUTER JOIN returns all rows from both.
A stored procedure is a reusable block of SQL statements saved in the database. It can accept parameters, perform data modifications, and return results. Stored procedures run on the database server, reducing network round trips.
Database normalization is the process of organizing tables to reduce data redundancy. It involves splitting data into related tables and defining relationships between them. Common forms are 1NF, 2NF, and 3NF.
Both are native Mac database clients. SQLPro Studio offers flexible subscription pricing including iOS access, a true lifetime license with updates forever, and a free year for students. See the full comparison at sqlprostudio.com/compare/tableplus.
SQLPro Studio is a native app with fast startup and low memory usage. DBeaver is Java-based and supports 80+ databases but uses more resources. See the full comparison at sqlprostudio.com/compare/dbeaver.
SQLPro Studio is a lightweight database client. DataGrip is a full JetBrains IDE with refactoring and VCS integration but higher resource usage. See the full comparison at sqlprostudio.com/compare/datagrip.
Both are multi-database tools. Navicat Premium offers enterprise features like ER diagrams and schema sync but costs around $699. SQLPro Studio covers core features at a fraction of the price. See the full comparison at sqlprostudio.com/compare/navicat.