Dedicated SSR (Server-side-rendered) Astro native Headless CMS, build from the ground up for the Astro community and by Astro community memb github.com/withstudiocms/studiocms
README.md

@withstudiocms/kysely #

codecov

A type-safe database client and migration system for StudioCMS, built on top of Kysely. Provides a unified interface for working with libSQL, MySQL, and PostgreSQL databases with runtime schema management and migrations.

Note: This is an internal StudioCMS package. It is not intended to be used directly outside of the StudioCMS ecosystem.

Features #

  • 🔒 Type-Safe Database Operations - Full TypeScript support with Kysely's type-safe query builder
  • 🗄️ Multi-Database Support - Works with libSQL (Turso), MySQL, and PostgreSQL
  • 🔄 Runtime Schema Management - Dynamic schema creation and validation
  • 🛡️ Error Handling - Custom error types for better debugging
  • 🚀 TypeScript-Based Migrations - File-based migrations with automatic tracking
  • 🔍 Schema Introspection - Inspect and validate database schemas at runtime
  • ⚡ Effect-ts Integration - Functional programming patterns with Effect-ts

License #

MIT Licensed