SQL Prompt

What is SQL Prompt?

Write, format, analyze, and refactor your SQL effortlessly

NO SQL SERVER MANAGEMENT STUDIO AND VISUAL STUDIO

• Advanced IntelliSense style code padding
• Code snippet library
• Refactor SQL code
• Fast and comprehensive code analysis
• History and coloring of the SSMS tab

Writing and formatting SQL code manually, even with IntelliSense, is downright very boring

So we created SQL Prompt Pro, which is not.

Available as an add-in for SQL Server Management Studio and Visual Studio, SQL Prompt Pro eliminates recoding.

In addition to automatically populating your code, SQL Prompt Pro takes care of formatting, renaming objects, and other distractions, so you can focus on how the code actually works.

Top Features for SSMS and Visual Studio

Formatting your code

Try formatting your own SQL code below with some predefined styles, or create and share your own styles with all the formatting options in SQL Prompt Pro.

Easily switch between styles with one click

Work in your own preferred style, then switch to the shared team style to work together, and to the enterprise-wide style when you're ready to ship.

Adjust your formatting

Advanced options allow you to adjust your formatting styles to leave them exactly as you like, and you can even share them with your friends and colleagues.

Format only what you need

Select a SQL script fragment that you want to format by simply selecting it, or disable formatting for certain blocks using our useful actions shortcut.

Navigating your code

Code padding with declaration expansion

Smart code autocomplete works as you type, providing suggestions to help make your encoding fast and accurate.

Script ing an object as ALTER

Use the SQL prompt to create a script for an object in a query by simply right-clicking and choosing Script object as ALTER from the menu.

Select an object in Object Explorer

With Prompt SQL, you can select an object or synonym of object search directly from the query window.

Find invalid SQL Server objects

Use the SQL prompt to find invalid objects in your database, as if you want to know if any objects are referencing other objects that have been deleted.

Find unused variables and parameters

The SQL prompt can find and highlight any parameters or variables that are not used in a script.

Instant access to schema information and summary scripts

Access your schema information and view a summary of the actions that a SQL script performs, in the order in which they occur.

Refactoring your code

Securely rename objects in your script

You can use Sql Prompt to rename all occurrences of a variable or alias in a query.

Encapsulate SQL as a new stored procedure

With SQL Prompt, you can create a new stored procedure from any valid SQL block.

Divide a table into your database

SQL Prompt can split a table in your database into two tables. This is useful if you want to normalize a database, improve database performance, or change database design.

Analyzing your code

Discover code issues and hidden traps as you type

More than 90 rules are available out of the box, all manageable in the Options menu. Code problems are underlined with quick hints when hovering and more details when you click the lamp icon.

Bring the code to the pattern with automatic corrections

After SQL Prompt code analysis highlights the problematic code, you can select the orange lamp icon and apply an automatic fix to bring your code to the default.

Get clear explanations and suggestions to improve your code

The side panel provides more information about the problem and how you can fix it, as well as links to read online.

Perform code reviews or analysis on a legacy code base

View a complete list of code issues detected in a SQL script, group them by type, and export them. This makes it much easier for a team to perform code reviews or analyze a legacy code base for possible refactoring improvements.

Encourage coding patterns with shared code analysis settings

You can choose which suggestions you want to see, save to a shared drive or source control folder, and share them with yourteam.

Features only in SSMS

Save and recover lost tabs

With tab history, you can save, view, and rename tabs - and restore previously opened tabs in SSMS. You can pick up work where you left off and start coding again in seconds.

Tab coloring

Set different colors for different groups, servers, and databases, so you can quickly and easily identify which environment you're working in within SSMS.

Intelligent renaming refactoring

Create a script that allows you to rename objects in your database without breaking dependencies.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768