chore: Upgrade pnpm, auto-sort package.json by ilyabo · Pull Request #624 · sqlrooms/sqlrooms

ilyabo · 2026-05-14T15:03:57Z

Summary by CodeRabbit

Chores
- Updated pnpm package manager from 10.29.3 to 11.1.2
- Standardized package.json field ordering across the monorepo for consistency
- Improved workspace build configuration with enhanced permission controls
- Refined source file detection for Next.js applications in unused code analysis
- Added automated package.json sorting to lint-staged configuration

coderabbitai · 2026-05-14T15:04:11Z

No actionable comments were generated in the recent review. 🎉

ℹ️ Recent review info

⚙️ Run configuration

Configuration used: defaults

Review profile: CHILL

Plan: Pro

Run ID: 960a662c-f28d-4096-b222-d473aacafc89

📥 Commits

Reviewing files that changed from the base of the PR and between 15f694b and c57f30d.

⛔ Files ignored due to path filters (1)

pnpm-lock.yaml is excluded by !**/pnpm-lock.yaml

📒 Files selected for processing (84)

.lintstagedrc.json
apps/sqlrooms-cli-ui/package.json
examples/ai-agent/package.json
examples/ai-core/package.json
examples/ai-nextjs/package.json
examples/ai-rag/package.json
examples/ai-subagents/package.json
examples/ai/package.json
examples/app-builder/package.json
examples/canvas-sync/package.json
examples/canvas/package.json
examples/code-editor/package.json
examples/color-scales/package.json
examples/cosmos-embedding/package.json
examples/cosmos/package.json
examples/deckgl-discuss/package.json
examples/deckgl-mosaic/package.json
examples/deckgl/package.json
examples/get-started/package.json
examples/kepler/package.json
examples/layout/package.json
examples/minimal/package.json
examples/mosaic/package.json
examples/multi-room/package.json
examples/nextjs/package.json
examples/notebook/package.json
examples/pivot/package.json
examples/query-motherduck/package.json
examples/query-pwa/package.json
examples/query-websocket/package.json
examples/query/package.json
examples/sync/package.json
knip.json
package.json
packages/ai-config/package.json
packages/ai-core/package.json
packages/ai-rag/package.json
packages/ai-settings/package.json
packages/ai/package.json
packages/artifacts/package.json
packages/canvas/package.json
packages/cells/package.json
packages/codemirror/package.json
packages/color-scales/package.json
packages/cosmos/package.json
packages/crdt/package.json
packages/data-table/package.json
packages/db-settings/package.json
packages/db/package.json
packages/deck/package.json
packages/discuss/package.json
packages/documents/package.json
packages/dropzone/package.json
packages/duckdb-core/package.json
packages/duckdb-node/package.json
packages/duckdb/package.json
packages/kepler-config/package.json
packages/kepler/package.json
packages/layout-config/package.json
packages/layout/package.json
packages/monaco-editor/package.json
packages/mosaic/package.json
packages/mosaic/src/MosaicSlice.ts
packages/motherduck/package.json
packages/notebook/package.json
packages/pivot/package.json
packages/preset-eslint/package.json
packages/preset-jest/package.json
packages/preset-typedoc/package.json
packages/recharts/package.json
packages/room-config/package.json
packages/room-shell/package.json
packages/room-store/package.json
packages/s3-browser-config/package.json
packages/s3-browser/package.json
packages/s3-utils/package.json
packages/schema-tree/package.json
packages/sql-editor-config/package.json
packages/sql-editor/package.json
packages/ui/package.json
packages/utils/package.json
packages/vega/package.json
packages/webcontainer/package.json
pnpm-workspace.yaml

📝 Walkthrough

Walkthrough

This PR integrates sort-package-json as a monorepo-wide build tool to standardize package.json field ordering. The changes add the tool to the root package configuration, wire it into lint-staged for pre-commit automation, update pnpm to 11.1.2, configure workspace build permissions, apply consistent field ordering across ~80 example and core package manifests, refine dead code detection for Next.js examples, and add a TypeScript suppression comment for known version incompatibility.

Changes

Package.json standardization with sort-package-json

Layer / File(s)	Summary
Tool integration and root configuration `.lintstagedrc.json`, `package.json`, `pnpm-workspace.yaml`	Adds `sort-package-json` as a dev dependency, creates `sort-package-json` and `sort-package-json:check` scripts in root, integrates into lint-staged configuration for `**/package.json` files, bumps pnpm from 10.29.3 to 11.1.2, and adds workspace-level `allowBuilds` configuration for per-package build permissions.
Example packages standardized `examples/ai-agent/package.json`, `examples/ai-core/package.json`, `examples/ai-nextjs/package.json`, `examples/ai-rag/package.json`, `examples/ai-subagents/package.json`, `examples/ai/package.json`, `examples/app-builder/package.json`, `examples/canvas-sync/package.json`, `examples/canvas/package.json`, `examples/code-editor/package.json`, `examples/color-scales/package.json`, `examples/cosmos-embedding/package.json`, `examples/cosmos/package.json`, `examples/deckgl-discuss/package.json`, `examples/deckgl-mosaic/package.json`, `examples/deckgl/package.json`, `examples/get-started/package.json`, `examples/kepler/package.json`, `examples/layout/package.json`, `examples/minimal/package.json`, `examples/mosaic/package.json`, `examples/multi-room/package.json`, `examples/nextjs/package.json`, `examples/notebook/package.json`, `examples/pivot/package.json`, `examples/query-motherduck/package.json`, `examples/query-pwa/package.json`, `examples/query-websocket/package.json`, `examples/query/package.json`, `examples/sync/package.json`	Applies consistent field ordering to 30+ example package manifests, moving `build` script before `dev`, reordering `overrides` blocks to appear earlier (especially `@duckdb/duckdb-wasm`), repositioning `version`, `private`, and `type` metadata fields, and standardizing `scripts`, `dependencies`, and `devDependencies` section order.
App packages standardized `apps/sqlrooms-cli-ui/package.json`	Reorders scripts, dependencies, and `@duckdb/duckdb-wasm` overrides in the CLI UI app package to match monorepo field ordering conventions.
Core and internal packages standardized `packages/ai-config/package.json`, `packages/ai-core/package.json`, `packages/ai-rag/package.json`, `packages/ai-settings/package.json`, `packages/ai/package.json`, `packages/artifacts/package.json`, `packages/canvas/package.json`, `packages/cells/package.json`, `packages/codemirror/package.json`, `packages/color-scales/package.json`, `packages/cosmos/package.json`, `packages/crdt/package.json`, `packages/data-table/package.json`, `packages/db-settings/package.json`, `packages/db/package.json`, `packages/deck/package.json`, `packages/discuss/package.json`, `packages/documents/package.json`, `packages/dropzone/package.json`, `packages/duckdb-core/package.json`, `packages/duckdb-node/package.json`, `packages/duckdb/package.json`, `packages/kepler-config/package.json`, `packages/kepler/package.json`, `packages/layout-config/package.json`, `packages/layout/package.json`, `packages/monaco-editor/package.json`, `packages/mosaic/package.json`, `packages/motherduck/package.json`, `packages/notebook/package.json`, `packages/pivot/package.json`, `packages/preset-eslint/package.json`, `packages/preset-jest/package.json`, `packages/preset-typedoc/package.json`, `packages/recharts/package.json`, `packages/room-config/package.json`, `packages/room-shell/package.json`, `packages/room-store/package.json`, `packages/s3-browser-config/package.json`, `packages/s3-browser/package.json`, `packages/s3-utils/package.json`, `packages/schema-tree/package.json`, `packages/sql-editor-config/package.json`, `packages/sql-editor/package.json`, `packages/ui/package.json`, `packages/utils/package.json`, `packages/vega/package.json`, `packages/webcontainer/package.json`	Standardizes field ordering across 45+ internal library and tool packages, moving repository metadata earlier, repositioning `scripts` and `publishConfig` (typically to follow `peerDependencies`), reordering `build`/`dev` script entries, and ensuring consistent `main`/`module`/`types`/`files` placement throughout the package ecosystem.
Configuration and tool refinements `knip.json`, `packages/mosaic/src/MosaicSlice.ts`	Updates knip.json Next.js dead code detection to include app router files at `src/app//{page.tsx,api//*.ts}`, and adds a TypeScript error suppression comment above the `duckDb: dbConnector.getDb()` initialization to document version mismatch handling.

Estimated code review effort

🎯 2 (Simple) | ⏱️ ~10 minutes

Possibly related PRs

sqlrooms/sqlrooms#490: Both PRs modify .lintstagedrc.json's staged command entries, including the ruff pipeline for Python linting.

Suggested labels

codex

Suggested reviewers

igorDykhta
dmitriy-kostianetskiy

Poem

🐰 A rabbit's ode to orderly bunrows:

Fields shuffled, scripts made tidy and neat,
Sort-package-json hops through the repo's fleet,
From ai to vega, the packages align,
Each manifest now dances in perfect design! ✨

🚥 Pre-merge checks | ✅ 5

✅ Passed checks (5 passed)

Check name	Status	Explanation
Description Check	✅ Passed	Check skipped - CodeRabbit’s high-level summary is enabled.
Title check	✅ Passed	The title accurately describes the main changes: upgrading pnpm and auto-sorting package.json files across the codebase.
Docstring Coverage	✅ Passed	No functions found in the changed files to evaluate docstring coverage. Skipping docstring coverage check.
Linked Issues check	✅ Passed	Check skipped because no linked issues were found for this pull request.
Out of Scope Changes check	✅ Passed	Check skipped because no linked issues were found for this pull request.

_{✏️ Tip: You can configure your own custom pre-merge checks in the settings.}

✨ Finishing Touches

📝 Generate docstrings

Create stacked PR
Commit on current branch

🧪 Generate unit tests (beta)

Create PR with unit tests
Commit unit tests in branch sort-package-json

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

_{Comment @coderabbitai help to get the list of available commands and usage tips.}

ilyabo · 2026-05-14T15:04:29Z

@copilot resolve the merge conflicts in this pull request

# Conflicts: # package.json Co-authored-by: ilyabo <[email protected]>

Copilot · 2026-05-14T15:09:08Z

@copilot resolve the merge conflicts in this pull request

Resolved in c57f30d by merging origin/main into this branch and fixing the package.json conflict. No UI changed here, so there isn’t a screenshot to include.

ilyabo added 6 commits May 14, 2026 15:20

yarn sort

c9ccade

sort-package-json

2035e09

fix knip

828c3d5

upgrade pnpm

4b9670a

knip

2e4dd24

typecheck

c86322a

Copilot started work on behalf of ilyabo May 14, 2026 15:04

View session

Merge remote-tracking branch 'origin/main' into sort-package-json

c57f30d

# Conflicts: # package.json Co-authored-by: ilyabo <[email protected]>

Copilot finished work on behalf of ilyabo May 14, 2026 15:09

ilyabo merged commit 4f9e7f3 into main May 14, 2026
2 checks passed

ilyabo deleted the sort-package-json branch May 14, 2026 15:31

coderabbitai Bot mentioned this pull request May 21, 2026

feat: Upgrade DuckDB to 1.5.3 #659

Merged

coderabbitai Bot mentioned this pull request Aug 4, 2026

chore(deps): migrate to VitePress 2 and Vite 8.2 #829

Merged

Navigation Menu

Repository navigation

chore: Upgrade pnpm, auto-sort package.json - #624

chore: Upgrade pnpm, auto-sort package.json#624
ilyabo merged 7 commits into
mainfrom
sort-package-json

ilyabo commented May 14, 2026 •

edited by coderabbitai Bot

Loading

Uh oh!

coderabbitai Bot commented May 14, 2026 •

edited

Loading

Walkthrough

Changes

Estimated code review effort

Possibly related PRs

Suggested labels

Suggested reviewers

Poem

Uh oh!

ilyabo commented May 14, 2026

Uh oh!

Copilot AI commented May 14, 2026

Uh oh!

Uh oh!

Reviewers

Uh oh!

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

Conversation

ilyabo commented May 14, 2026 • edited by coderabbitai Bot Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Summary by CodeRabbit

Uh oh!

coderabbitai Bot commented May 14, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Walkthrough

Changes

Estimated code review effort

Possibly related PRs

Suggested labels

Suggested reviewers

Poem

Uh oh!

ilyabo commented May 14, 2026

Uh oh!

Copilot AI commented May 14, 2026

Uh oh!

Uh oh!

Reviewers

Uh oh!

Assignees

Labels

Projects

Milestone

Development

Uh oh!

2 participants

ilyabo commented May 14, 2026 •

edited by coderabbitai Bot

Loading

coderabbitai Bot commented May 14, 2026 •

edited

Loading