Shardingsphere
Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Install / Use
/learn @apache/ShardingsphereREADME
Apache ShardingSphere - Enterprise Distributed Database Ecosystem
Building the standards and ecosystem on top of heterogeneous databases, empowering enterprise data architecture transformation
Official Website: https://shardingsphere.apache.org/
OVERVIEW
<hr>Apache ShardingSphere is positioned as Database Plus, a standard and ecosystem built on top of heterogeneous databases. As an operating system layer above databases, ShardingSphere does not create new databases but focuses on maximizing the computing capabilities of existing databases, providing unified data access and enhanced computing capabilities.
Database Plus Core Concept: By building a standardized and scalable enhancement layer above databases, it makes heterogeneous databases as simple to use as a single database, providing unified governance capabilities and distributed computing capabilities for enterprise data architectures.
Connect, Enhance, and Pluggable are the three core pillars of Apache ShardingSphere:
-
Connect: Building database upper-layer standards, quickly connecting applications with multi-modal heterogeneous databases through flexible adaptation of database protocols, SQL dialects, and storage formats, providing unified data access experience;
-
Enhance: As a database computing enhancement engine, transparently providing enterprise-grade capabilities including distributed computing (data sharding, readwrite-splitting, SQL federation), data security (encryption, masking, audit), traffic control (circuit breaker, rate limiting), and observability (monitoring, tracing, analysis);
-
Pluggable: Adopting a micro-kernel + 3-layer pluggable architecture to achieve complete decoupling of kernel, functional components, and ecosystem integration. Developers can flexibly customize unique data architecture solutions that meet enterprise needs, just like building with LEGO blocks.
Differentiation Advantages:
- vs Distributed Databases: More lightweight, protecting existing investments, avoiding vendor lock-in
- vs Traditional Middleware: Richer features, more complete ecosystem, more flexible architecture
- vs Cloud Vendor Solutions: Support multi-cloud deployment, avoid technology binding, autonomous and controllable
ShardingSphere became an Apache Top-Level Project on April 16, 2020, and has been adopted by 19,000+ projects worldwide.
DUAL-ACCESS ARCHITECTURE DESIGN
<hr>ShardingSphere adopts a unique dual-access architecture design, providing two access ends - JDBC and Proxy - that can be deployed independently or in hybrid deployment, meeting diverse requirements for different scenarios.
ShardingSphere-JDBC: Lightweight Access End
Positioning: Lightweight Java framework, enhanced JDBC driver
Core Features:
- Client-side direct connection: Shares resources with applications, decentralized architecture
- High performance, low overhead: Direct database connection with minimal performance loss
- Complete compatibility: Compatible with all ORM frameworks (MyBatis, JPA, Hibernate, etc.)
- Zero additional deployment: Provided as JAR package, no independent deployment and dependencies required
Use Cases: High-performance Java applications, integrated deployment with business applications, pursuing ultimate performance
ShardingSphere-Proxy: Enterprise Access End
Positioning: Transparent database proxy, independently deployed server-side
Core Features:
- Static entry point: Independent deployment from applications, providing stable database access entry
- Heterogeneous language support: Supports any MySQL/PostgreSQL protocol compatible client
- DBA friendly: Database operation and maintenance management interface, convenient for O&M personnel
- Enterprise-grade features: Supports cluster deployment, load balancing, failover
Use Cases: Heterogeneous language environments, database operation and maintenance management, enterprise applications requiring unified access entry
Hybrid Architecture Advantages
By hybridizing ShardingSphere-JDBC and ShardingSphere-Proxy with unified configuration through the same registry center, you can flexibly build application systems suitable for various scenarios:
- Architectural flexibility: Architects can freely adjust the optimal system architecture
- Scenario adaptability: Select the most suitable access method according to different business scenarios
- Unified management: Single configuration, multi-end collaboration, simplifying O&M complexity
- Progressive evolution: Support smooth evolution path from JDBC to Proxy
AI ABSTRACTION
[.
prose
336.2kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
82.8kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
82.8kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
