Vibetype's database migrations. https://maev.si
  • PLpgSQL 97.5%
  • Shell 2%
  • Dockerfile 0.5%
Find a file
semantic-release-bot 6737adfdf1 chore(release): 11.1.0 [skip ci]
## [11.1.0](https://github.com/maevsi/sqitch/compare/11.0.1...11.1.0) (2026-04-11)

### Features

* **reccoom:** add role ([4c0e10c](4c0e10c278))
2026-04-11 11:52:00 +00:00
.github feat(reccoom): add role 2026-04-11 13:35:03 +02:00
.vscode chore(ide): shorten vscode default formatter setting 2026-02-18 07:35:24 +01:00
docs perf: inline functions 2026-03-09 18:26:01 +01:00
src feat(reccoom): add role 2026-04-11 13:35:03 +02:00
test feat(reccoom): add role 2026-04-11 13:35:03 +02:00
.dockerignore chore(docker): pin checksum on debezium postgres image (#138) 2025-01-31 23:44:12 +01:00
.editorconfig chore: add editorconfig 2023-11-04 00:38:28 +01:00
.gitignore feat: setup own repository 2023-05-13 00:44:16 +02:00
.imgbotconfig docs(postgres): explain roles and vacuum (#181) 2025-03-31 11:26:05 +02:00
.nvmrc chore(deps): update node.js to v24 2025-10-28 19:43:23 +00:00
.releaserc ci(release): use conventional commits 2023-09-12 12:50:23 +02:00
.renovaterc chore(renovate): remove package rules 2023-06-02 11:24:03 +02:00
AGENTS.md docs(agents): add instructions 2026-04-03 02:21:49 +02:00
CHANGELOG.md chore(release): 11.1.0 [skip ci] 2026-04-11 11:52:00 +00:00
CODE_OF_CONDUCT.md docs: create code of conduct 2024-10-13 02:06:44 +02:00
CODEOWNERS chore(git): add code owner 2026-02-20 05:11:28 +01:00
CONTRIBUTING.md chore(deps): remove commitlint 2025-08-19 20:18:11 +02:00
docker-entrypoint.sh refactor(environment)!: dissolve target variable file 2025-03-17 15:00:19 +01:00
Dockerfile feat(reccoom): add role 2026-04-11 13:35:03 +02:00
package.json chore(release): 11.1.0 [skip ci] 2026-04-11 11:52:00 +00:00
pnpm-lock.yaml chore(deps): update dependency conventional-changelog-conventionalcommits to v9.3.1 2026-04-01 17:57:36 +00:00
README.md chore(sqitch): work around ipv6 issue 2026-01-26 05:17:35 +01:00

Sqitch

Sqitch

Sqitch is the database migration tool driving Vibetype.

📋 Table of Contents

  1. 🛠️ Quickstart
  2. 📚 Documentation
  3. 🚀 Preview

🛠️ Quickstart

Make sure you understand what Sqitch does, i.e. have a look into Sqitch's documentation.

This project is designed to be used within the maevsi/stack. To get started, follow the Vibetype fullstack setup guide. Once your development environment is running, use these commands to manage database migrations:

npm run deploy            # apply database migrations
npm run revert            # roll back database migrations

npm run test              # execute test suite
npm run test:data:add     # add test data migration
npm run test:data:remove  # remove test data migration
npm run test:update       # update test fixtures

After setup, you can inspect and test GraphQL queries and mutations using GraphiQL at https://postgraphile.localhost/graphiql.

💡 You can run npm run sqitch <command> [options] to access full Sqitch functionality.

📚 Documentation

To fully understand the quick start commands above and Vibetype's database concepts, check out the onboarding and in-depth guides below.

🧭 Onboarding

  1. Project
    1. Code Structure
    2. Contributing
    3. Code of Conduct
  2. Database concepts
    1. Roles
    2. Row Level Security

🔍 In-Depth Guides

  1. Project
    1. Code Structure
    2. Changelog
  2. Database concepts
    1. Row Level Security
    2. Vacuuming

🚀 Preview

Heres a visual overview of what Sqitch creates (click here to zoom in):

Database Schema