encore-database

Manage Encore.ts database access with typed queries, migrations, and Drizzle ORM integration.

26|5|Updated Jan 8, 2026
One-click install
npx skills add https://github.com/encoredev/skills --skill encore-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: encore-database
Source: https://github.com/encoredev/skills/tree/main/encore/database
Command: npx skills add https://github.com/encoredev/skills --skill encore-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Managing database access, migrations, and type-safe queries in Encore.ts can be verbose and error-prone. This Skill centralizes query methods, migrations, and ORM integration to streamline data handling.

Core Features & Use Cases

  • Type-safe query interfaces (query, queryRow, exec) for multi-row, single-row, and write operations.
  • Built-in migrations support with structured file naming and automatic application on startup.
  • Drizzle ORM integration for schema-driven data access and easy migrations management.

Quick Start

Install and configure Encore’s database tooling to run migrations and perform typed queries against your database.

Frequently Asked Questions about encore-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run type-safe database queries in Encore.ts?

You can run type-safe database queries in Encore.ts using built-in query methods like query, queryRow, and exec. These methods handle multi-row reads, single-row lookups, and write operations with safe parameterization and structured TypeScript results.

How do I manage database migrations automatically with Encore.ts?

Encore.ts manages database migrations using structured file naming conventions with automatic application on startup. This built-in support ensures schema changes apply seamlessly without manual intervention during deployment.

Can I use Drizzle ORM with Encore.ts for schema-driven data access?

Yes, Encore.ts supports Drizzle ORM integration for schema-driven data access. This provides typed query methods and easy migrations management, allowing you to define schemas and interact with data safely.

What is the best way to structure database access and data integrity in Encore.ts?

The best way to structure database access in Encore.ts is applying centralized query methods and ORM integration to service layers. This approach ensures data integrity by performing typed multi-row reads, single-row lookups, and write operations safely.

Do I need TypeScript and Encore SQLDatabase utilities to perform typed database operations?

Yes, performing typed database operations requires TypeScript and Encore SQLDatabase utilities. Optional Drizzle integration is also available to ensure safe parameterization, migrations handling, and structured results.