# Overview

Derby is a database management system (DBMS), accessed by applications through the JDBC API. Included with the product are some standalone Java tools and utilities that make it easier to use and develop applications for Derby.

These tools and utilities include:

- ij

  `ij` is Derby's interactive JDBC scripting tool. It is a simple utility for running scripts against a Derby database. You can also use it interactively to run ad hoc queries. `ij` provides several commands for ease in accessing a variety of JDBC features.

  `ij` can be used in an embedded or a client/server environment.

- sysinfo

  `sysinfo` provides information about your version of Derby and your environment.

- dblook

  `dblook` is Derby's Data Definition Language (DDL) Generation Utility, more informally called a schema dump tool. It is a simple utility that dumps the DDL of a user-specified database to either a console or a file. The generated DDL can then be used for such things as recreating all or parts of a database, viewing a subset of a database's objects (for example, those which pertain to specific tables and schemas), or documenting a database's schema.

- SignatureChecker

  The `SignatureChecker` tool identifies any SQL functions and procedures in a database that do not follow the SQL Standard argument matching rules.

- Environment setup and the Derby tools
  The tools ij, sysinfo, dblook, and SignatureChecker can all be used in either an embedded or a client/server environment.

Parent topic: What are the Derby tools and utilities?
Related concepts
About Derby databases
JDBC connection basics
Tools and localization