Sqrach

A SQL scratch pad created to help experienced developers write SQL quickly.

Sqrach is a syntax highlighted SQL editor with intelligent autocomplete functionality to help you minimize typing and flush out ideas quickly

Sqrach supports MySql, MariaDB, SQLite, Sql Server.

Designed for developers, Sqrach gives you perspective on the data, and suggests autocompletes and hints that help you focus on what you are creating instead of looking up details of the data structure. Sqrach suggests appropriate autocompletes for where you are, suggests relevant joins, keeps frequenly used columns handy, and reminds you of dependecies.

For more details check out the Sqrach guide.

Sql Editor / Autocomplete

• Sql syntax is colored in editor
• Intelligent autocomplete popup appears as you type, offering appropriate suggestions for columns, tables and joins, and SQL keywords.
• Optionally auto-insert table aliases and auto-insert tables in from clause with joins
• Autosaves your queries so you don't loose them when you close your editor for the day.
• Suggests likely modifications to your query that you frequently do such as group or order clauses, appropriate for the given query.
• Name your queries.
• Keeps a history of your queries and enables you to scroll through previous versions of your queries so you can refer back to them.
• Knows data types and database structure and suggests appropriate autocompletes.
• Knows what columns and tables are within scope at each place in the query.
• Quickly scaffold statements like insert, update and select.

Results View

• With a click you can expand columns in the results view so you can see all the column data.
• You can group individual columns to the left so you can compare column data side by side without having to rewrite the query.
• Export results to file in different formats including, csv, tsv, custom.
• Generate initializers for json, c# arrays and objects from query results.
• Expanded selection options and copy result data to clipboard in different formats.
• Track query execution duration and data loading time.

Object View

• Helps you keep track of columns and tables you are working with.
• Creates query scaffolding quickly
• You can select which tables and columns you want to work with so you don't have to scroll through the table structure tediously
• Highlights the columns that are primary keys and shows data type
• Highlights relationships between tables and shows columns included in foreign keys.
• Optionally performs basic and extended profiling of the data so you can visually see the structure of the data graphically and view details about data in columns including: min, mean, max, cardinality. (note: data profiling is currently supported only in MySql at this point.)
• Identifies which columns are good candidates for group and order clause.
• Highights the columns that are nullable so you don't forget to consider the possibility of nulls in your query.
• With the graphical table relationship viewer you can visualize the relationships between tables explicitly defined foreign keys or optionally inferred through analysis of column names and primary keys.

Query Parser

• Optionally manages table aliases
• Optionally automatically include tables in from clause with appropriate joins
• See the structure of your queries, subqueries, and relationships between tables and columns.
• With the graphical query viewer you can visualize the query structure in different ways to highlight certain aspects: table relationships, columns, where