IvorySQL Skills — Empowering AI assistants to become IvorySQL database experts.
npx skills add IvorySQL/skillsgit clone https://github.com/IvorySQL/skills.git <target-directory>Download the skills package archive and extract it to the OpenClaw skills directory.
ivorysql-skills/
├── SKILL.md # Package-level entry point (routing center)
├── README.md # Documentation
│
├── ivorysql/ # Primary skill (product overview)
│ └── references/ # Reference documentation
├── ivorysql-app-builder/ # End-to-end application development
│ └── references/ # Reference documentation
├── ivorysql-architecture/ # Architecture design
│ └── references/ # Reference documentation
...
This skills package provides AI assistants with professional expertise and development guidance for the IvorySQL database. IvorySQL is an open-source relational database built on the PostgreSQL kernel with Oracle compatibility.
This project originated from ivorysql-skills, a personal project by IvorySQL contributor Shawn Yan, who has also made many other contributions to the community. Special thanks to Shawn Yan!
https://mp.weixin.qq.com/s/t27mnhLrt_EXB8BVnYIhpQ
| Skill | Description |
|---|---|
ivorysql |
Primary skill entry point, product overview |
ivorysql-deployment |
Installation & deployment (Docker/K8s/source) |
ivorysql-architecture |
Architecture design (dual parser/dual port) |
ivorysql-config |
System configuration (GUC/parameters) |
ivorysql-security |
Security configuration (privileges/auditing/TDE) |
ivorysql-ha |
High availability (backup/replication/monitoring) |
| Skill | Description |
|---|---|
ivorysql-app-builder |
End-to-end application development |
ivorysql-jdbc |
Java JDBC development |
ivorysql-python |
Python development (psycopg/SQLAlchemy) |
ivorysql-go |
Go development (pgx/GORM) |
ivorysql-csharp |
C#/.NET development (Dapper/EF Core) |
ivorysql-nodejs |
Node.js development (pg/Sequelize/Prisma) |
ivorysql-c |
C language development (libpq/ECPG) |
ivorysql-odbc |
Cross-platform ODBC development |
| Skill | Description |
|---|---|
ivorysql-sql |
SQL syntax (DDL/DML/queries) |
ivorysql-functions |
Built-in functions (string/date/aggregate) |
ivorysql-plisql |
PL/iSQL stored procedures |
ivorysql-oracle-compat |
Oracle compatibility features (21 items) |
ivorysql-migration |
Data migration (Oracle/MySQL → IvorySQL) |
| Skill | Description |
|---|---|
ivorysql-faq |
Frequently asked questions |
ivorysql-ecosystem |
Ecosystem integration |
ivorysql-tools |
Client tools |
- Dual Port: 5432 (PG mode) + 1521 (Oracle mode)
- Dual Parser: Oracle syntax + PostgreSQL syntax
- Oracle Compatible: 21 compatibility features
- PG Kernel: 100% compatible with the PostgreSQL ecosystem
# Quick start with Docker
docker run -d --name ivorysql \
-p 5432:5432 -p 1521:1521 \
-e POSTGRES_PASSWORD=secret \
ivorysql/ivorysql:5.3
# Connect (Oracle mode)
psql -h localhost -p 1521 -U ivorysql ivorysql
# Connect (PG mode)
psql -h localhost -p 5432 -U ivorysql ivorysqlApache 2.0