Firebird Editor Pro

Powerful Firebird administration tool with object browser, SQL editor, data grid, BLOB editor, backup and restore, database compare, data pump, database source script and database documentation.

Version 24.2.0 Oct 24, 2026

Free for any use · All downloads

Firebird Editor Pro showing the columns of a table in the object browser
01 / 07

Connections

Connection profiles, several connections at the same time and recovery of lost connections.

Connection manager

Save connections as profiles, organize them in groups, give them colors and clone them. Sort by profile or by last connect.

Several connections

Every connection opens in its own tab. Tabs can show the group, user and server, and are restored when you start again.

Client library and protocol

Choose the client library, protocol, port, character set, SQL dialect and role for each connection, and add extra parameters freely.

  • TCP
  • Local
  • 46 character sets
  • Dialect 1 and 3

Secure connections

SSL with client certificates, trusted authentication, login prompt at connect time and encrypted storage of saved passwords.

New

Lost connection recovery

When a connection drops, a banner offers to reconnect, or the program reconnects automatically at a set interval.

Create database

Create a new database with character set, dialect and a page size from 4096 to 32768.

Import and export connections

Import connections from DBeaver, InterBase Query and Firebird Editor Pro. Export connections to a file.

Connection defaults

Define sets of default values such as group, server, user, client library and character set for new connections. Drop a database file on the window to connect.

02 / 07

Object browser

The objects of the database in a tree, with source, dependencies and grants.

17 object types

The objects of the database grouped by type, with a filter. System objects can be shown.

  • Tables
  • Views
  • Procedures
  • Functions
  • Packages
  • Triggers
  • Sequences
  • Exceptions
  • Roles
  • Domains
  • Indices
  • Constraints
  • UDFs
  • UDR functions
  • UDR procedures
  • UDR triggers
  • Collations

Tables

Columns with keys, domains, defaults and comments, primary and foreign keys, checks, unique constraints, indices, triggers and the data itself.

  • Columns
  • Constraints
  • Indices
  • Triggers
  • Data
  • Dependencies
  • Source
  • Grants

Source of every object

Each object has a syntax highlighted DDL source tab with search. Packages show header and body, procedures and functions their parameters.

Dependencies and grants

See what an object depends on and what depends on it, and who has which privileges, including grant and admin options.

DDL generation

CREATE and DROP statements for every object, ALTER for sequences, domains and table columns, trigger activation, comments, grants and revokes are generated.

Search the database

Find a string in object names, table and view columns, domains and in the source of procedures, functions, triggers and packages.

Firebird 3, 4 and 5

Packages, stored functions, external routines and identity columns are supported, along with the newer data types.

  • INT128
  • DECFLOAT
  • TIME WITH TIME ZONE
  • TIMESTAMP WITH TIME ZONE
  • BOOLEAN

Sequences and indices

Change the value of a sequence, see index properties and statistics, and recalculate the statistics of one index or all of them.

03 / 07

SQL editor

SQL editor with the editor control of Text Editor Pro, code completion and execution plan.

Run statements and scripts

Execute the selection or the whole text. Queries return a result grid, everything else runs as a script, in the background with a cancel button.

Execution plan

See the detailed explained plan of a query, or show the plan without executing the statement at all.

Editable results

Edit the result set of a query and commit or roll back. The reason is shown when a result set cannot be edited.

Parameters

Values for query parameters are asked when you run, including NULL, empty strings and Unicode text.

Transaction control

Commit and roll back explicitly, or switch on auto commit. An execution log records what was run and how long it took.

Code completion

Tables, views, columns, procedures, functions, packages, keywords and the aliases of your statement, with parameter types.

Templates and snippets

Generate SELECT, INSERT, UPDATE, DELETE and MERGE statements, or insert CREATE templates for tables, views, procedures, functions, packages, triggers and other objects. Add your own snippets with shortcuts.

History and saved statements

Executed statements are kept in the SQL history. Frequently used statements can be saved to a list.

SQL formatter

Thirteen layout rules, indentation settings and separate capitalization for keywords, tables, columns, functions and seven other element types.

Editor features

Multiple carets, synchronized editing, code folding, minimap, bookmarks, matching pairs, search with a search map and editable color themes.

Object tree

Insert object names and generated statements from the tree beside the editor, or open the object in the object browser.

Files and printing

Work with several SQL files in tabs with auto save, and print with preview, headers, footers and line numbers.

04 / 07

Data grid and BLOBs

View and edit table data and BLOBs.

Data grid

Column filters, a search panel that highlights matches, sorting, zoom, auto-fit and jump to column. Data that is not fully fetched is sorted and filtered by the server.

Edit table data

Insert, delete and edit rows with commit and rollback. Set a field to NULL, to its default or to a new GUID.

Record tools

View one record as a column list, compare two records field by field, and fill keys from a sequence you attach to the grid.

BLOB editor

Open a BLOB as text with JSON, SQL and XML highlighting and formatting, as an image, as a PDF, as a web page or in the hex editor.

  • Text
  • Image
  • PDF
  • Hex
  • Web
New

Save BLOBs to folder

Save the BLOBs of one column or of all BLOB columns to files. File names come from the primary key and the file type is detected from the content.

BLOB details

See the size, detected image type and a hash of a BLOB, and load or save its content as a file.

  • CRC32
  • MD5
  • SHA1
  • SHA256
  • SHA512

Display formats

System or custom date and time formats, decimals by scale, thousand separators and BLOBs shown as text.

05 / 07

Export, script and document

Data export, database source script, data pump and database documentation.

Export data

Export any grid, and table data also as SQL statements. Computed columns, identity columns and BLOBs can be left out.

  • Excel
  • CSV
  • JSON
  • HTML
  • Text
  • SQL INSERT
  • SQL UPDATE

Import and clipboard

Load records from JSON, and copy grid data to the clipboard for spreadsheets and documents.

Database source script

Build a complete DDL script of the database with a switch for every object category, grants and sequence values, and save it as SQL.

Data pump

Generate a data migration script with tables ordered by their foreign keys. It can disable triggers, recreate constraints, update sequences and commit in batches.

Database documentation

Produce a browsable document of the database objects with a table of contents, and save it as HTML or PDF.

06 / 07

Administration

Backup, restore, monitoring and database compare.

Backup

Back up through the services API with live output, parallel workers, metadata-only and skip-data options, and backup compression.

Restore

Restore to a new or existing database with a new page size, deactivated indexes, commit after each table and parallel workers.

Active connections

See who is connected, from where and with which program, and close a selected connection or all others.

Active transactions

Monitor running transactions with their SQL text, start time, client process and page reads, writes and fetches.

Compare databases

Compare the objects of two connections across 13 object types and inspect every difference in a side-by-side DDL diff.

Database info

Server, client and ODS versions, dialect, default character set, page size, database size, creation date and encryption state.

07 / 07

Customization

Options, skins, color themes and scaling.

52 option pages

Options for connections, data grids, BLOB editor, SQL editor, SQL formatter, skins and more, with a search.

Skins and themes

Seven built-in skins with more to download, adjustable colors and effects, and editable color themes for the SQL editor.

Scaling and fonts

Automatic, percentage (100 to 300 percent) or pixels-per-inch scaling, rounded corners, and separate fonts for each part of the editor.

Application options

Multiple instances, minimize to the system tray, stay on top and automatic update checks.

Screenshots

Details

Price
Free for personal, academic, commercial and government use. See the license.
Firebird
Firebird 2.5, 3, 4 and 5, through the client library of your choice.
Platforms
Windows 64-bit x64 and Arm64EC and 32-bit x86.
Packages
EXE installer, MSI installer, and portable ZIP and 7-Zip packages.
Privacy
No registration and no data collection. Read the privacy statement.
History
133 releases since 2020. Change log.
Data access
Devart IBDAC, with backup and restore through the Firebird services API.
Technology
Native code written in Delphi with the open-source TTextEditor and TDatabaseGrid controls.