Can I use this to create collections programmatically?

Absolutely. The skill includes specific patterns for creating Base, Auth, and View collections using the PocketBase JavaScript migration API.

Does this skill support PocketBase auto-migrations?

Yes, it provides guidance on using the default auto-migrate mode in development and explains how to transition to manual migrations for production stability.

What happens if a migration fails?

PocketBase uses a transactional instance for migrations; if any error occurs during execution, the entire migration is rolled back to maintain database integrity.

Can I run raw SQL with this skill?

Yes, it includes examples for executing raw SQL queries within migrations for tasks that require direct database manipulation or bypass the schema cache.

How does it handle production deployments?

It outlines best practices such as disabling automigrate in production and using environment variables for sensitive credentials like superuser emails and passwords.

PocketBase Migrations

Name: PocketBase Migrations
Author: davila7

bydavila7

•

24,164

•

数据库管理

Manages schema migrations, versioning, and programmatic collection creation for PocketBase databases.

This skill empowers Claude with specialized knowledge to handle the complete lifecycle of PocketBase schema management. It provides comprehensive patterns for using the PocketBase CLI, managing auto-migrate workflows, and writing robust JavaScript migration files. From creating complex collection types—including base, auth, and view collections—to implementing raw SQL and handling application bootstrapping, this skill ensures that database changes are versioned, reversible, and consistent across development and production environments.

主要功能

01Automated and manual schema migration workflows

0224,164 GitHub stars

03Reversible migration templates with UP and DOWN logic

04Safe deployment patterns using snapshots and history-sync

05Programmatic collection creation for base, auth, and view types

06CLI command integration for migration history and snapshots

使用场景

01Initializing a production-ready schema with version-controlled migrations

02Syncing collection structures between local development and remote environments

03Automating the creation of superusers and initial app settings during deployment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add davila7/claude-code-templates pocketbase

For use in Claude.ai and ChatGPT

主要功能

01Automated and manual schema migration workflows

0224,164 GitHub stars

03Reversible migration templates with UP and DOWN logic

04Safe deployment patterns using snapshots and history-sync

05Programmatic collection creation for base, auth, and view types

06CLI command integration for migration history and snapshots

使用场景

01Initializing a production-ready schema with version-controlled migrations

02Syncing collection structures between local development and remote environments

03Automating the creation of superusers and initial app settings during deployment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add davila7/claude-code-templates pocketbase

For use in Claude.ai and ChatGPT