SQLLY Development
Firebird Development Studio

Firebird Development Studio actually consists of two products - Firebird SQL Studio to work with physical database and Firebird Database Designer to virtually design your database.

Firebird SQL Studio
Firebird SQL Studio comes with following power-packed features:
Intelligent Code Completion.
Code Completion is a "must have" feature for the mordern programming environment. And of course it is supported in IB/FB Development Studio. It works as smart as possible - it does not show just a list of reserved words and database object names. Instead it checks the syntax of the statement you writing and shows the list of words that fits the syntax requirements. Here is an example of how Code Completion works:
Refactoring — uniquely available to SQL programmers.
You can change your project structure to accommodate new features, requirements, or external systems. Unfortunately, many simultaneous changes in an InterBase/Firebird database can force you to delete and recreate a large portion of your database. For example, if you want to rename a stored procedure used in dozens of other procedures and triggers, you cannot easily pass dependencies between objects. A simple rename can take a whole day of your development time. Adding one more parameter to the stored procedure used in half of the rest procedures can chew up even more of your valuable time. InterBase/Firebird Development Studio solves these problems—through an approach called Refactoring, available now, for the first time, to SQL coders. Refactoring is well-known in Java, C++ and Pascal. Only InterBase/Firebird Development Studio makes this powerful approach available to SQL programmers. Database Editor and Database Designer provide this powerful feature on the menu. You can perform the following actions:
Dynamic syntax and errors highlighting — making your development efforts a breeze
For the first time, you can get this feature in a dynamic database development solution. SQL code highlights in different colors dynamically as you edit. See all errors immediately—powered by our full-featured SQL syntax parser. No more typing errors! Now, you can even check your code for logic errors, as in the following example: The code has two fields in the SELECT statement and only one variable specified for the output. The parser generates the following message:
Invalid number of parameters (1), should be 2.
When you type a field or variable name that does not exist, the error highlights, as in the following example: The location variable is not defined, so it appears in red, as do the table fields. Customize your color settings. Each type of object can have a different color: table names, fields, variables, and reserved words. See details in Options > Code Editor
SQL Debugger — making your code error free in a snap
You can now debug your stored procedures and triggers quickly and easily. SQL Debugger has a complete set of tools: step over and trace into, breakpoints, conditional breakpoints, and a watch list. And SQL Debugger also offers features specifically for SQL: Result Data, Statement Plan, and statement execution statistics.
Database Comparer — updating your production database in minutes
Want to update your production database with a new metadata structure in minutes? With InterBase/Firebird Development Studio, you can drop a grueling, manual process required in most database development environments. Database Comparer is your ideal solution. Deploy a new database structure in minutes—select your development database, choose a production database, and click Compare. The resulting script contains all statements required to update your production database. You can review the script and execute it quickly. Note: Back up your production database before running any scripts that are generated automatically.
Select, Update, Insert and Delete Procedures — effectively designing your database
One of the most effective ways to design a database is to access data through stored procedures. Firebird Development Studio allows you to automatically create stored procedures based on your table structure. Just click the appropriate menu command on the table context menu in Database Designer or Database Editor.
Database Statistics Analyzer — pinpointing hidden performance problems.
Now, you can save your valuable time by streamlining the presentation of your database statistics to pinpoint database performance problems. Bad indices can decrease your database performance. InterBase/Firebird makes these problems difficult to find by presenting database statistics that are difficult to read. However, now you can easily read your database statistics with the Statistics Analyzer in the Administrative Console tool.
 
More screenshots...
Firebird Database Designer
ER diagrams are the best, most efficient way to start your database development. The diagrams are crucial to the initial development stages. However, creating a working prototype of your system is almost impossible if you use only ER diagrams and the corresponding table definitions. To use the simplest autoincrement field with InterBase/Firebird, you must create a generator to get a unique sequence and a trigger or a stored procedure to fill your field with values from the generator. At the time of development, you must synchronize an ER diagram with your development database and also create infrastructure objects to make your database work. In most scenarios, you would need different tools to create ER diagrams and code procedures and triggers. However, what do you do if you make changes in the development database as a result of testing? In most cases, you would have to manually make your changes in the ER diagram to keep it synchronized with the database. However, this is usually not the only problem. You must store your database object code somewhere so that you can search it. And the cumbersome list of manual changes and updates goes on and on.
Database Designer is your power-packed tool for getting rid of these cumbersome, manual processes. The designer makes your project development much easier, faster, and more accurate. First, Database Designer acts as a code repository, providing efficient storage for your database code that is separate from the development database. The Database Designer can store any type of database objects, right along with the ER diagrams. Database Designer has a built-in version control system that automatically allows you to keep changes history for any object and develop your database in a team of programmers. And, of course, you can deploy your "virtual" database for real-world testing and debugging at any time.
At the initial development stage, you can use ER diagrams to start your project. With Database Designer, you can actually create database objects for prototyping your application. Gradually, you can add more and more power to your database using one integrated environment. You won’t lose code again with the integrated version control system. At any time, you can deploy changes to the development database for further testing and debugging.
At any time, you can easily import extensive changes back to your project and continue development with Database Designer. You might guess that coding the database virtually can produce many simple syntax errors in the code. However, the Validate Project feature in Database Designer checks your code for syntax and some logic errors. After this check, you can be sure that your code is correct—and your real database will be updated in a few clicks. Your work is effective and bug free with our advanced features like refactoring, code completion and dynamic syntax and errors highlighting. More screenshots...