Apache Derby

Apache Derby is an open-source relational database implemented entirely in Java, formerly governed by the Apache Software Foundation (retired October 2025). It provides a small-footprint (~3.5MB) database engine with full SQL support, JDBC compliance, ACID transactions, stored procedures, and triggers. Derby operates in both embedded mode (bundled inside Java applications) and client/server mode via the Derby Network Server.

Apache Derby is listed with 1 API on the APIs.io network. Tagged areas include Apache, Database, Embedded, Java, and JDBC.

The Apache Derby catalog on APIs.io includes 1 JSON-LD context and 1 Spectral governance ruleset.

Apache Derby’s developer surface includes developer portal, documentation, getting-started guide, Stack Overflow tag, and 11 more developer resources.

🌐 Visit website 📡 Profile data on GitHub

28.3/100 thin ▬ flat Agent 2/100 human only self hosted · Apache-2.0 Full breakdown ↓
scored 2026-11-06 · rubric v0.27.0 · Show this score on your site →

AccessFreemium

1 API 6 Features 4 Use Cases

Apache Database Embedded Java JDBC Open Source Relational SQL

Kin Score

Kin Score How this is scored →
scored 2026-11-06 · rubric v0.27.0

Composite quality — 28.3/100 · thin

Contract Quality 6.2 / 21

Developer Ergonomics 8.1 / 17

Access Clarity 1.3 / 17

Operational Transparency 2.3 / 11

Contract Governance 1.0 / 10

Discoverability 4.9 / 9

Regulatory Posture 2.5 / 15

Agent readiness — 2/100 · human only

Machine-Readable Contract 0 / 18

Agentic Access Contract 0 / 10

Documented Reversibility 0 / 6

MCP Server 0 / 12

Machine-Readable Auth 0 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 7 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Delegated User Identity 0 / 6

Protected Resource Metadata 0 / 5

Registration Without a Human 0 / 6

Agentic Commerce Well-Known Document 0 / 5

Pagination 5 / 5

Distinct Operations 3 / 3

MCP Tool Quality 6 / 6

Regulatory Posture applies to this provider. Its tags matched the Horizontal (data, software, accessibility, platform) regime, so Regulatory Posture carries 15 points of the composite. If this regime is wrong for your business, say so on your provider repo — the applicability map is public and we will correct it.

Create-or-Update Ergonomics could not be measured. We hold no machine-readable contract for this provider to read, so there is nothing to measure a write surface against. Excluded rather than scored zero: never-measured and measured-empty are different facts. Publishing an OpenAPI is what makes this facet — and several others — scorable at all.

The six quality facets above are damped to 85 points between them, because the conditional facet above carries the other 15. That is why each facet's contribution is shown against a damped maximum: raising a quality facet moves the composite by 85% of its nominal weight, not 100%. The full arithmetic is at apis.io/rating/.

Show this score on your site.

It updates itself when the score changes. Paste this where you link to your API docs:

<a href="https://apis.io/providers/apache-derby/"><img src="https://apis.io/badge/apache-derby/card.svg" alt="Apache Derby on APIs.io — Kin Score by API Evangelist"></a>

Other styles, a README pill and a shields.io endpoint are on the badge page.

Raise your score.

Agent readiness — checks not met, largest first (exact, from this profile):

Machine-Readable Contract +18 pts — api_specs includes an OpenAPI document
MCP Server +12 pts — deployment.mode + probe verdict on the mcp/ manifest, not the pointer; an unprobed slug falls back to authorship
Agentic Access Contract +10 pts — agentic_access artifact present (x-agentic-access), graded by author
Machine-Readable Auth +10 pts — a served openid-configuration/oauth-authorization-server carrying `issuer` (served), else the securitySchemes class in the provider OpenAPIs — bound (mutualTLS, DPoP, Signature) > negotiable (oauth2 authorizationCode/clientCredentials, openIdConnect) > bearer (http bearer, apiKey)
Idempotency +9 pts — OpenAPI mutating operations declare an idempotency key — a header, a request-body property, or a named de-duplication token whose own description says so (verified); else common[].type matches /idempoten/i (documented)
Stable Error Semantics +8 pts — OpenAPI $refs a shared error schema across 4xx/5xx responses (verified), else common[].type includes ErrorCatalog / ErrorCodes / DeclineCodes

11 more unmet checks in the Agent Readiness table above.

Kin Score — facets with the most composite points still available (weight × headroom):

Access Clarity scores 7.9 — up to +18.4 composite points
Contract Quality scores 29.2 — up to +17.7 composite points
Contract Governance scores 9.8 — up to +10.8 composite points

Each check links to what satisfies it. Publish the artifact, or tell us where it already lives, and the score moves on the next scoring run.

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. Every facet and dimension name above is a link: it opens that measurement's own page — what it means, the exact checks that feed it, how the whole catalog distributes on it, and the providers at the top of it. This rating is computed from the provider profile at artifacts.apis.io/apache-derby/apis.yml: open an issue on github.com/api-evangelist/apache-derby to ask a question or point us at an artifact you publish. Submit an artifact on GitHub — free → Manage your own listing — the Influence plan, $499/mo →

Standards implemented 1

Standards this provider implements or carries. De facto ones are profiled and measured by the API Commons; formal ones come from the standards directory and are linked by the provider's own tags. The evidence column says how each claim was established — not that it was made.

JDBC

tagged — the provider's own APIs.json carries the standard as a tag; implementation not verified

APIs 1

Individual APIs this provider publishes, each with its own machine-readable definition.

Apache Derby

Derby provides a standard JDBC API for database operations in both embedded (org.apache.derby.jdbc.EmbeddedDriver) and client/server (org.apache.derby.jdbc.ClientDriver) modes, ...

Apache Derby API pricing

Not yet checked against Apache Derby's own pricing page. Compiled by API Evangelist on 2026-05-04; confirm before you rely on a figure. A free plan or tier is listed.

Plan	Price
Free freemium	Free
Professional paid	Free
Enterprise enterprise	—

Plan details, limits and sources →

Rate limits

Free Tier Default: 10 requests per minute
Free Tier Monthly Quota: 1000 requests per month
Professional Tier Default: 100 requests per minute

Compiled by API Evangelist, not yet checked against Apache Derby's documentation. All 5 limits →

Pricing Plans 1

Published pricing tiers and plan structures.

Apache Derby Plans Pricing

3 plans

PLANS

Rate Limits 1

Documented rate limits and quota policies.

Apache Derby Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Apache Derby Finops

FINOPS

Features 6

Notable capabilities this provider offers.

Embedded Mode

Derby can be embedded directly in Java applications as a library, providing a zero-administration database with no separate server process required.

Client/Server Mode

Derby Network Server supports multiple concurrent JDBC clients connecting over TCP/IP using the Derby Network Client driver.

Full SQL Support

Supports ANSI SQL-92 with extensions including subqueries, joins, constraints, triggers, views, stored procedures, and user-defined functions.

ACID Transactions

Full ACID transaction support with row-level locking, MVCC-style isolation levels, and savepoints.

Small Footprint

The base Derby engine and embedded JDBC driver is approximately 3.5MB, making it suitable for desktop and embedded applications.

Java Stored Procedures

Supports Java-based stored procedures and functions callable directly from SQL using standard JDBC interfaces.

Semantic Vocabularies 1

JSON-LD contexts and semantic vocabularies used across these APIs.

Apache Derby Context

2 classes · 15 properties

JSON-LD

Spectral Rules 1

Spectral governance rulesets for linting and validating these APIs.

Apache Derby — jsonschema rules

5 rules · 3 warnings 2 info

SPECTRAL

JSON Schema 2

Standalone JSON Schema definitions for this provider's data models.

ConnectionConfig

10 properties

JSON SCHEMA

TableInfo

5 properties

JSON SCHEMA

JSON Structure 2

JSON Structure definitions describing this provider's data shapes.

Apache Derby Connection Config Structure

10 properties

JSON STRUCTURE

Apache Derby Table Info Structure

5 properties

JSON STRUCTURE

Examples 2

Example request and response payloads for these APIs.

Apache Derby Connection Config Example

10 fields

EXAMPLE

Apache Derby Table Info Example

4 fields

EXAMPLE

Security Posture 2

Authentication, domain security, vulnerability disclosure, and trust-center signals.

Apache Derby Domain Security

TLSv1.3 · HSTS · DMARC

SECURITY

Apache Derby Vulnerability Disclosure

security.txt · contact published

SECURITY

Use Cases 4

What developers build with this provider.

Embedded Application Database

Embed Derby in desktop Java applications, IDEs, or tools that need a local SQL database without a separate server.

Unit and Integration Testing

Use Derby as an in-memory or on-disk test database for Java application integration tests with JDBC.

Lightweight Development Database

Use Derby as a development database when production uses a heavier RDBMS, without installing MySQL or PostgreSQL.

Data Migration and ETL

Use Derby as a staging database for ETL processes in Java-based data pipelines.

Integrations 5

Pre-built integrations with other platforms and tools.

JDBC

Derby provides JDBC 4.0/4.1/4.2 compliant embedded and network client drivers.

Spring Framework

Commonly used with Spring DataSource and JPA/Hibernate for test database configuration.

Hibernate / JPA

Derby has a Hibernate dialect (DerbyDialect) for ORM integration.

Apache Maven

Derby artifacts are available on Maven Central under org.apache.derby group ID.

Eclipse IDE

Eclipse IDE includes Derby as a built-in SQL explorer and development database.

Resources

Get Started 2

Portal, sign-up, and the first successful call

Portal

Portal

GettingStarted

GettingStarted

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Design & Contract 1

Pagination, idempotency, versioning, errors, and events

Vocabulary

Vocabulary

Build 3

SDKs, sample code, and the tooling you integrate with

CodeOfConduct

CodeOfConduct

GitHubRepository

GitHubRepository

GitHubOrganization

GitHubOrganization

Access & Security 2

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Operate 2

Status, limits, changes, and where to get help

RateLimits

RateLimits

StackOverflow

StackOverflow

Commercial 3

Pricing, plans, and the legal terms of use

Plans

Plans

FinOps

FinOps

License

License

Company 1

The organization behind the API

Website

Website

Source (apis.yml)

aid: apache-derby
name: Apache Derby
description: Apache Derby is an open-source relational database implemented entirely in Java, formerly governed by the Apache
  Software Foundation (retired October 2025). It provides a small-footprint (~3.5MB) database engine with full SQL support,
  JDBC compliance, ACID transactions, stored procedures, and triggers. Derby operates in both embedded mode (bundled inside
  Java applications) and client/server mode via the Derby Network Server.
type: Index
deliveryModel:
  model: self-hosted
  license: Apache-2.0
  open_source: true
  commercial: false
  callable_host: false
  label: Self-hosted open source · you run it yourself
  confidence: high
  source:
  - license
  generated: '2026-08-28'
  method: derived
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: low
  source:
  - plans
  - security
  generated: '2026-11-06'
  method: derived
position: Consuming
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-derby.png
tags:
- Apache
- Database
- Embedded
- Java
- JDBC
- Open Source
- Relational
- SQL
tags_raw:
- Apache
- Database
- Embedded
- Java
- JDBC
- Open Source
- Relational
- SQL
- Open-Source
created: '2026-03-16'
modified: '2026-09-16'
url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/apis.yml
specificationVersion: '0.23'
apis:
- aid: apache-derby:apache-derby
  name: Apache Derby
  description: Derby provides a standard JDBC API for database operations in both embedded (org.apache.derby.jdbc.EmbeddedDriver)
    and client/server (org.apache.derby.jdbc.ClientDriver) modes, supporting full SQL, stored procedures, triggers, views,
    indexes, and complete ACID transaction management. The Derby Network Server also exposes a simple text-based administrative
    protocol.
  humanURL: https://db.apache.org/derby/manuals/index.html
  tags:
  - Embedded
  - Java
  - JDBC
  - Network Server
  - SQL
  - Transaction
  tags_raw:
  - Embedded
  - Java
  - JDBC
  - Network Server
  - SQL
  - Transactions
  properties:
  - type: Documentation
    url: https://db.apache.org/derby/manuals/index.html
  - type: GettingStarted
    url: https://db.apache.org/derby/quick_start.html
  - type: APIReference
    url: https://db.apache.org/derby/javadoc/publishedapi/jdbc4/
  - type: GitHubRepository
    url: https://github.com/apache/derby
  - type: SDKs
    url: https://mvnrepository.com/artifact/org.apache.derby/derby
    title: derby (Maven Central)
  - type: SDKs
    url: https://mvnrepository.com/artifact/org.apache.derby/derbyclient
    title: derbyclient (Maven Central)
  - type: SDKs
    url: https://mvnrepository.com/artifact/org.apache.derby/derbynet
    title: derbynet Network Server (Maven Central)
  - type: JSONSchema
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-schema/apache-derby-connection-config-schema.json
    title: Connection Config
  - type: JSONSchema
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-schema/apache-derby-table-info-schema.json
    title: Table Info
  - type: JSONStructure
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-structure/apache-derby-connection-config-structure.json
  - type: JSONStructure
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-structure/apache-derby-table-info-structure.json
  - type: JSONLD
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/json-ld/apache-derby-context.jsonld
  - type: Examples
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/examples/apache-derby-connection-config-example.json
  - type: Examples
    url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/examples/apache-derby-table-info-example.json
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com
common:
- type: Plans
  url: plans/apache-derby-plans-pricing.yml
- type: RateLimits
  url: rate-limits/apache-derby-rate-limits.yml
- type: FinOps
  url: finops/apache-derby-finops.yml
- type: Website
  url: https://apache.org
- type: CodeOfConduct
  url: https://github.com/apache/.github/blob/main/.github/CODE_OF_CONDUCT.md
- type: License
  name: Apache-2.0
  url: https://github.com/apache/derby/blob/trunk/LICENSE
- type: VulnerabilityDisclosure
  url: security/apache-derby-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-derby-domain-security.yml
- type: Portal
  url: https://db.apache.org/derby/
- type: Documentation
  url: https://db.apache.org/derby/manuals/index.html
- type: GettingStarted
  url: https://db.apache.org/derby/quick_start.html
- type: GitHubRepository
  url: https://github.com/apache/derby
- type: GitHubOrganization
  url: https://github.com/apache
- type: StackOverflow
  url: https://stackoverflow.com/questions/tagged/apache-derby
- type: Features
  data:
  - name: Embedded Mode
    description: Derby can be embedded directly in Java applications as a library, providing a zero-administration database
      with no separate server process required.
  - name: Client/Server Mode
    description: Derby Network Server supports multiple concurrent JDBC clients connecting over TCP/IP using the Derby Network
      Client driver.
  - name: Full SQL Support
    description: Supports ANSI SQL-92 with extensions including subqueries, joins, constraints, triggers, views, stored procedures,
      and user-defined functions.
  - name: ACID Transactions
    description: Full ACID transaction support with row-level locking, MVCC-style isolation levels, and savepoints.
  - name: Small Footprint
    description: The base Derby engine and embedded JDBC driver is approximately 3.5MB, making it suitable for desktop and
      embedded applications.
  - name: Java Stored Procedures
    description: Supports Java-based stored procedures and functions callable directly from SQL using standard JDBC interfaces.
- type: UseCases
  data:
  - name: Embedded Application Database
    description: Embed Derby in desktop Java applications, IDEs, or tools that need a local SQL database without a separate
      server.
  - name: Unit and Integration Testing
    description: Use Derby as an in-memory or on-disk test database for Java application integration tests with JDBC.
  - name: Lightweight Development Database
    description: Use Derby as a development database when production uses a heavier RDBMS, without installing MySQL or PostgreSQL.
  - name: Data Migration and ETL
    description: Use Derby as a staging database for ETL processes in Java-based data pipelines.
- type: Integrations
  data:
  - name: JDBC
    description: Derby provides JDBC 4.0/4.1/4.2 compliant embedded and network client drivers.
  - name: Spring Framework
    description: Commonly used with Spring DataSource and JPA/Hibernate for test database configuration.
  - name: Hibernate / JPA
    description: Derby has a Hibernate dialect (DerbyDialect) for ORM integration.
  - name: Apache Maven
    description: Derby artifacts are available on Maven Central under org.apache.derby group ID.
  - name: Eclipse IDE
    description: Eclipse IDE includes Derby as a built-in SQL explorer and development database.
- type: Vocabulary
  url: https://raw.githubusercontent.com/api-evangelist/apache-derby/refs/heads/main/vocabulary/apache-derby-vocabulary.yaml

Apache Derby API — frequently asked questions

Does Apache Derby have an API?

Yes. APIs.io lists 1 API from Apache Derby, including Apache Derby.

How much does the Apache Derby API cost?

APIs.io lists 3 pricing plans for Apache Derby, with each plan's price, limits and inclusions under Pricing on this page.

Is the Apache Derby API ready for AI agents?

Apache Derby has a Kin Score of 28.3 out of 100 (thin) and an Agent Readiness score of 1.9 (human-only), scored by API Evangelist on 2026-11-06.

Work with this as data

Every provider here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for providers

9 MCP tools reach this

find_providersBrowse and filter every provider in the catalog.
get_provider_artifactsEvery artifact this provider publishes, grouped by type.
get_provider_operationsEvery operation across all of their OpenAPIs — one call instead of parsing every spec.
get_provider_toolsEvery MCP tool they ship, with the operation each wraps.
get_provider_evidenceHow each part of their score was established. Free — the basis for a claim should not sit behind it.
get_provider_ratingPRO — composite, band, trend and facet scores.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This provider

curl "https://apis.io/api/v1/providers/apache-derby"

All providers

curl "https://apis.io/api/v1/providers?limit=25"

Every operation they expose

curl "https://apis.io/api/v1/providers/apache-derby/operations?limit=25"

How their score was established

curl "https://apis.io/api/v1/providers/apache-derby/evidence"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.