Apache ShardingSphere

Apache ShardingSphere is an open-source ecosystem for distributed database systems providing data sharding, distributed transactions, and database governance. It supports MySQL, PostgreSQL, and other databases with transparent sharding capabilities.

Apache ShardingSphere publishes 5 APIs on the APIs.io network, including Cluster API, Databases API, DataSources API, and 2 more. Tagged areas include Database, Distributed SQL, Read-Write Splitting, Sharding, and SQL.

The Apache ShardingSphere catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Apache ShardingSphere’s developer surface includes documentation and 8 more developer resources.

🌐 Visit website 📡 Source on GitHub

43.1/100 developing ▼ -5.1 Agent 22/100 agent aware Full breakdown ↓
scored 2026-07-28 · rubric v0.6

AccessFreemium

5 APIs 7 Features 4 Use Cases

DatabaseDistributed SQLRead-Write SplittingShardingSQLApacheOpen Source

Kin Score

Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6

Composite quality — 43.1/100 · developing

Contract Quality 14.0 / 25

Developer Ergonomics 1.7 / 20

Commercial Clarity 7.9 / 20

Operational Transparency 4.8 / 13

Governance 8.3 / 12

Discoverability 6.5 / 10

Agent readiness — 22/100 · agent aware

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

MCP Server 0 / 12

Machine-Readable Auth 0 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 0 / 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

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/apache-shardingsphere: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 5

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

Rate Limits 1

Documented rate limits and quota policies.

Apache Shardingsphere Rate Limits

5 limits

RATE LIMITS

FinOps 1

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

Apache Shardingsphere Finops

FINOPS

Features 7

Notable capabilities this provider offers.

Database Sharding

Horizontal database sharding with flexible sharding algorithms

Read-Write Splitting

Transparent primary/replica read-write splitting

Distributed Transactions

XA and BASE distributed transaction support

Data Encryption

Transparent data encryption at the SQL layer

Shadow Database

Shadow database for production traffic testing

DistSQL

SQL-based distributed database management language

Database Federation

Query across heterogeneous database instances

Scroll for all 7

JSON Schema 14

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

Scroll for all 14

JSON Structure 14

JSON Structure definitions describing this provider's data shapes.

Scroll for all 14

Examples 14

Example request and response payloads for these APIs.

Scroll for all 14

Use Cases 4

What developers build with this provider.

Database Scale-Out

Horizontally scale relational databases without changing application code

Multi-Tenant Sharding

Shard data by tenant ID for SaaS applications

Read Scaling

Scale read traffic with primary/replica splitting

Data Migration

Online data migration between database clusters

Integrations 5

Pre-built integrations with other platforms and tools.

MySQL

MySQL-compatible sharding and proxy

PostgreSQL

PostgreSQL protocol support for sharding

Apache ZooKeeper

Cluster coordination and configuration storage

Spring Boot

ShardingSphere Spring Boot starter for Java applications

Kubernetes

Kubernetes operator for cloud-native deployment

Resources

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Design & Contract 3

Pagination, idempotency, versioning, errors, and events

SpectralRules

SpectralRules

Vocabulary

Vocabulary

JSONLD

JSONLD

Build 1

SDKs, sample code, and the tooling you integrate with

GitHubOrganization

GitHubOrganization

Access & Security 2

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Company 1

The organization behind the API

LinkedIn

Source (apis.yml)

aid: apache-shardingsphere
name: Apache ShardingSphere
description: Apache ShardingSphere is an open-source ecosystem for distributed database systems providing data sharding, distributed
  transactions, and database governance. It supports MySQL, PostgreSQL, and other databases with transparent sharding capabilities.
type: Index
accessModel:
  pricing: freemium
  onboarding: unknown
  trial: false
  try_now: false
  public: false
  label: Freemium
  confidence: medium
  source:
  - plans
  generated: '2026-07-22'
  method: derived
position: Consumer
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-shardingsphere.png
tags:
- Database
- Distributed SQL
- Read-Write Splitting
- Sharding
- SQL
- Apache
- Open Source
created: '2026-03-16'
modified: '2026-04-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-shardingsphere/refs/heads/main/apis.yml
specificationVersion: '0.19'
apis:
- aid: apache-shardingsphere:apache-shardingsphere-cluster-api
  name: Apache ShardingSphere Cluster API
  description: The Cluster API from Apache ShardingSphere — 1 operation(s) for cluster.
  humanURL: https://shardingsphere.apache.org/document/current/en/overview/
  tags:
  - Cluster
  properties:
  - type: OpenAPI
    url: openapi/apache-shardingsphere-cluster-api-openapi.yml
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/en/overview/
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/
- aid: apache-shardingsphere:apache-shardingsphere-databases-api
  name: Apache ShardingSphere Databases API
  description: The Databases API from Apache ShardingSphere — 2 operation(s) for databases.
  humanURL: https://shardingsphere.apache.org/document/current/en/overview/
  tags:
  - Databases
  properties:
  - type: OpenAPI
    url: openapi/apache-shardingsphere-databases-api-openapi.yml
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/en/overview/
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/
- aid: apache-shardingsphere:apache-shardingsphere-datasources-api
  name: Apache ShardingSphere DataSources API
  description: The DataSources API from Apache ShardingSphere — 1 operation(s) for datasources.
  humanURL: https://shardingsphere.apache.org/document/current/en/overview/
  tags:
  - DataSources
  properties:
  - type: OpenAPI
    url: openapi/apache-shardingsphere-datasources-api-openapi.yml
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/en/overview/
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/
- aid: apache-shardingsphere:apache-shardingsphere-readwritesplitting-api
  name: Apache ShardingSphere ReadwriteSplitting API
  description: The ReadwriteSplitting API from Apache ShardingSphere — 1 operation(s) for readwritesplitting.
  humanURL: https://shardingsphere.apache.org/document/current/en/overview/
  tags:
  - ReadwriteSplitting
  properties:
  - type: OpenAPI
    url: openapi/apache-shardingsphere-readwritesplitting-api-openapi.yml
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/en/overview/
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/
- aid: apache-shardingsphere:apache-shardingsphere-shardingrules-api
  name: Apache ShardingSphere ShardingRules API
  description: The ShardingRules API from Apache ShardingSphere — 1 operation(s) for shardingrules.
  humanURL: https://shardingsphere.apache.org/document/current/en/overview/
  tags:
  - ShardingRules
  properties:
  - type: OpenAPI
    url: openapi/apache-shardingsphere-shardingrules-api-openapi.yml
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/en/overview/
  - type: Documentation
    url: https://shardingsphere.apache.org/document/current/
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com
common:
- type: AgenticAccess
  url: agentic-access/apache-shardingsphere-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/apache-shardingsphere-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-shardingsphere-domain-security.yml
- type: LinkedIn
  url: https://www.linkedin.com/showcase/apache-shardingsphere
- type: GitHubOrganization
  url: https://github.com/apache/shardingsphere
- type: Documentation
  url: https://shardingsphere.apache.org/
- type: SpectralRules
  url: rules/apache-shardingsphere-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/apache-shardingsphere-vocabulary.yaml
- type: JSONLD
  url: json-ld/apache-shardingsphere-context.jsonld
- type: Features
  data:
  - name: Database Sharding
    description: Horizontal database sharding with flexible sharding algorithms
  - name: Read-Write Splitting
    description: Transparent primary/replica read-write splitting
  - name: Distributed Transactions
    description: XA and BASE distributed transaction support
  - name: Data Encryption
    description: Transparent data encryption at the SQL layer
  - name: Shadow Database
    description: Shadow database for production traffic testing
  - name: DistSQL
    description: SQL-based distributed database management language
  - name: Database Federation
    description: Query across heterogeneous database instances
- type: UseCases
  data:
  - name: Database Scale-Out
    description: Horizontally scale relational databases without changing application code
  - name: Multi-Tenant Sharding
    description: Shard data by tenant ID for SaaS applications
  - name: Read Scaling
    description: Scale read traffic with primary/replica splitting
  - name: Data Migration
    description: Online data migration between database clusters
- type: Integrations
  data:
  - name: MySQL
    description: MySQL-compatible sharding and proxy
  - name: PostgreSQL
    description: PostgreSQL protocol support for sharding
  - name: Apache ZooKeeper
    description: Cluster coordination and configuration storage
  - name: Spring Boot
    description: ShardingSphere Spring Boot starter for Java applications
  - name: Kubernetes
    description: Kubernetes operator for cloud-native deployment

Apache ShardingSphere

APIs 5

Pricing Plans 1

Rate Limits 1

FinOps 1

Features 7

Database Sharding

Read-Write Splitting

Distributed Transactions

Data Encryption

Shadow Database

DistSQL

Database Federation

Semantic Vocabularies 1

Spectral Rules 2

JSON Schema 14

JSON Structure 14

Examples 14

Security Posture 2

Agentic Access 1

Use Cases 4

Database Scale-Out

Multi-Tenant Sharding

Read Scaling

Data Migration

Integrations 5

MySQL

PostgreSQL

Apache ZooKeeper

Spring Boot

Kubernetes

Documentation 1

Agent Surfaces 1

Design & Contract 3

Build 1

Access & Security 2

Company 1

Source (apis.yml)