CDS pluginCDS plugintypeInstalls into a CAP project and extends the runtime. CAP loads it through cds.requires or the plugin hook.See every one →What this type is →by SAPby SAPoriginPublished by SAP itself. A visible facet, never an input to a reading — a dormant official plugin reads exactly like a dormant independent one.See every one →

@cap-js/sqlite

The SQLite service, in memory during the inner loop — which is why a CAP project runs before anyone has provisioned a database.

Facts

Latestv3.1.2ReleasedLast pushLicenceApache-2.0

Where it sits

Lives in
Provides
Database connectorsCAPDatabase connectorscapabilityConnecting an application’s data model and queries to a database, including the differences in supported queries, types and schema management between database implementations. Changing an existing schema belongs to [schema evolution](capability:schema-evolution).
Part of
@cap-js/cds-dbs@cap-js/cds-dbsartifactThe monorepo behind CAP's SQL database services — the base service, SQLite, PostgreSQL and HANA all live here, which is why they version together.
Flavors
Requires
@sap/cds^10@sap/cdsartifactThe peer range, as published.

Who is behind it

SAP Cloud Application Programming ModelSAP Cloud Application Programming ModelOrganisationMaintains this
In the atlas: maintains 34
@cap-js
maintainerJohannes VogtPersonContributes to this
In the atlas: maintains 1, contributes to 28, wrote 10
@Akatuoro
Arley Triana MorinPersonContributes to this
In the atlas: contributes to 9, wrote 1
@arleytm
Andreas SchmidtPersonContributes to this
In the atlas: contributes to 6
@aschmidt93
Bob den OsPersonContributes to this
In the atlas: contributes to 13
@BobdenOs
Andre MeyeringPersonContributes to this
In the atlas: contributes to 10
@bugwelle
CAP BotPersonContributes to this
In the atlas: contributes to 5
@cap-bots
Christian GeorgiPersonContributes to this
In the atlas: maintains 1, contributes to 53
@chgeo
Christian SchüringsPersonContributes to this
In the atlas: contributes to 25
@cschuerings
Daniel HutzelPersonContributes to this
In the atlas: contributes to 32, wrote 3
@danjoa
Daniel O'GradyPersonContributes to this
In the atlas: contributes to 10
@daogrady
35 contributors

Before choosing this

Conditions

LicenceSAP Developer License Agreement 3.2 CAP§ 1, 2, 3A cds-plugin is used with SAP CAP materials, or an artifact is explicitly identified as a CAP plugin or application.
  • § 1 License. Productive customer applications are limited to SAP BTP or another SAP-licensed platform, and mass extraction to a non-SAP product is restricted except where solely required for SAP interoperability.
  • § 2 Intellectual Property. The agreement retains SAP's rights in the covered materials and limits making APIs, tools or software available to third parties, while preserving ownership of customer applications subject to SAP's underlying rights.
  • § 3 Artificial Intelligence Training. The agreement prohibits use of the covered materials and customer applications for training artificial-intelligence models or systems.
SAP Developer License Agreement 3.2 CAP →

Also, from Database connectors§ 1: The connector itself does not decide the licence boundary. Section 1 makes the destination and purpose of extraction relevant, including the scoped exception for interoperability with an SAP product.

What it declares

Every artifact

Type
CDS plugin
Origin
By SAP

As a CDS plugin

Declared for
^10
Distributed through
npm

Connections8

@cap-js/sqlite connections@cap-js/sqlitePROVIDES→ provides1provides stated Auto-configures an in-memory SQLite database for the development profile through the cds-plugin technique, a persistent file when configured, and since @sap/cds 10.1.0 the sqlite:memory preset in any profile. Using SQLite for Development — capire: https://cap.cloud.sap/docs/guides/databases/sqliteDatabase connectorsUSED BY← optionally used by4optionally used by derived If: The local vector embeddings are used: capire states the plugin requires @sap/cds ^10.1 and @cap-js/sqlite ^3.1 for them. The recommendations and the AICore service do not involve SQLite. The database the plugin redirects so that the vector functions run against a local ONNX model instead of the character-hash emulation. Through: inverted from its requires edge CAP-native Embeddings, SQLite and H2 — capire, source on GitHub: https://raw.githubusercontent.com/cap-js/docs/main/guides/ai/embeddings.md@cap-js/aiifoptionally used by derived If: When the SQLite store is selected. The README requirements table specifies ^1 with cds 8, ^2 with cds 9, and ^3 with cds 10. Through: inverted from its requires edge cds-caching — Requirements: https://github.com/mikezaschka/cds-caching/blob/main/README.mdcds-cachingifoptionally used by derived If: the project is run locally rather than deployed The database the project reads `db/data/my.bookshop-Books.csv` into while it is run locally. Through: inverted from its requires edge ui5-cap-serverside-rendering-demo — package.json, devDependencies: https://raw.githubusercontent.com/lemaiwo/ui5-cap-serverside-rendering-demo/main/package.jsonui5-cap-serverside-rendering-demoifoptionally used by derived If: the cds runtime is run in the browser through the node() and cap() plugins the database the cds runtime deploys to when the model is compiled and served in the browser Through: inverted from its requires edge vite-plugin-cds — README, cds in the browser: https://raw.githubusercontent.com/Akatuoro/vite-plugin-cds/main/README.mdvite-plugin-cdsif← used by2used by derived Replication cache requires [@cap-js/sqlite](artifact:cap-js-sqlite) as a production dependency, not only a development dependency. Through: inverted from its requires edge CAP Node.js Community Common — Replication Cache: https://github.com/cap-js-community/common/blob/main/README.md@cap-js-community/commonused by derived For the entity-cache strategy. Through: inverted from its requires edge cds-data-federation — Caching Federated Entities: https://mikezaschka.github.io/cds-data/federation/integration/caching.htmlcds-data-federationLINEAGE→ part of1part of stated cap-js/cds-dbs — README: https://github.com/cap-js/cds-dbs cap-js/cds-dbs — README: https://github.com/cap-js/cds-dbs@cap-js/cds-dbs

Install

npm add @cap-js/sqlite

Derived from the package name. No recipe recorded; the README has the configuration.

README

quoted from cap-js/cds-dbs under Apache-2.0, read
cap-js/cds-dbs/sqlite/README.mdOn GitHub

CDS database service for SQLite

Welcome to the SQLite database service for SAP Cloud Application Programming Model Node.js, based on streamlined database architecture and better-sqlite driver.

Setup

If you want to use SQLite for development, all you need to do is to install the database package, as follows

npm add @cap-js/sqlite -D

Learn more about setup and usage in the respective database guide.

Support

This project is open to feature requests/suggestions, bug reports etc. via GitHub issues.

Contribution

Contribution and feedback are encouraged and always welcome. For more information about how to contribute, the project structure, as well as additional contribution information, see our Contribution Guidelines.

Versioning

This library follows Semantic Versioning. All notable changes are documented in CHANGELOG.md.

Code of Conduct

We as members, contributors, and leaders pledge to make participation in our community a harassment-free experience for everyone. By participating in this project, you agree to abide by its Code of Conduct at all times.

Licensing

Copyright 2024 SAP SE or an SAP affiliate company and cds-dbs contributors. Please see our LICENSE for copyright and license information. Detailed information including third-party components and their licensing/copyright information is available via the REUSE tool.

Apache-2.0, read

History

Latest

v3.1.2

Dependencies 1

Notes
Dependencies
  • The following workspace dependencies were updated
    • dependencies
      • @cap-js/db-service bumped from ^3.1.1 to ^3.1.2
  1. v3.1.1

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^3.1.0 to ^3.1.1
  2. v3.1.0

    Features 1, Fixes 1, Dependencies 1

    Notes
    Added
    • Add support for cds.Vector on SQLite and Postgres (#1676) (f0d2203)
    Fixed
    • INSERT.from(SELECT) used non-existent value (#1565) (fd98844)
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^3.0.1 to ^3.1.0
  3. v3.0.2

    Fixes 1

    Notes
    Fixed
    • prevent SQLite in memory connection from being cleaned up (#1672) (9b9e2b3)
  4. v3.0.1

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^3.0.0 to ^3.0.1
  5. v3.0.0dated in the atlas

    Breaking 1, Features 2, Dependencies 1

    Notes
    ⚠ BREAKING CHANGES
    Added
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.11.0 to ^3.0.0
  6. v2.4.0

    Features 1, Dependencies 1

    Notes
    Added
    • supersede potentially compromised release (#1590) (3be4044)
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.10.1 to ^2.11.0
  7. v2.3.0

    Features 1, Fixes 1, Dependencies 1

    Notes
    Added
    Fixed
    • supersede potentially compromised release (#1589) (bd73895)
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.10.0 to ^2.10.1
  8. v2.2.1

    Fixes 1, Dependencies 1

    Notes
    Fixed
    • sqlite generated key is named lastInsertRowid (#1501) (a4d3437)
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.9.0 to ^2.10.0
  9. v2.2.0

    Features 1, Fixes 2, Dependencies 1

    Notes
    Added
    Fixed
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.8.2 to ^2.9.0
  10. v2.1.3

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.8.1 to ^2.8.2
  11. v2.1.2

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.8.0 to ^2.8.1
  12. v2.1.1

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.7.0 to ^2.8.0
  13. v2.1.0

    Features 1, Dependencies 1

    Notes
    Added
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2.6.0 to ^2.7.0
  14. v2.0.4

    Dependencies 1

    Notes
    Dependencies
    • The following workspace dependencies were updated
      • dependencies
        • @cap-js/db-service bumped from ^2 to ^2.6.0
  15. v2.0.3

    Fixes 1

    Notes
    Fixed
    • associations in [@cds](https://github.com/cds).search are additive (#1355) (ea931cb)
  16. v2.0.2

    Fixes 1

    Notes
    Fixed
    • deps: update dependency better-sqlite3 to v12 (#1253) (8975490)
  17. v2.0.1

    Changed 1

    Notes
    Changed
  18. v2.0.0dated in the atlas

    Breaking 3, Features 1, Changed 3

    Notes
    ⚠ BREAKING CHANGES
    • update peer dependency to @sap/cds@9 (#1178)
    • update dependency to @cap-js/db-service@2 (#1178)
    • Unfiltered db constraint errors (#1165)
    Added
    Changed
  19. v1.11.0

    Features 1

    Notes
    Added
  20. v1.10.0

    Features 1

    Notes
    Added
  21. v1.9.0

    Features 1

    Notes
    Added
    • pass through of arbitrary client options (#1024) (b090ccd)
  22. v1.8.0

    Features 1

    Notes
    Added
  23. v1.7.8

    Fixes 1

    Notes
    Fixed
    • default [development] URL to :memory: (#926) (51e8aa7)
  24. v1.7.7

    Fixes 1

    Notes
    Fixed
  25. v1.7.6

    Fixes 1

    Notes
    Fixed
    • increase min version cap-js/db-service (#876) (e20eef8)
  26. v1.7.5

    Fixes 1

    Notes
    Fixed
    • properly support default, cds.on.insert and cds.on.update for UPSERT queries (#425) (338e9f5)
  27. v1.7.4

    Fixes 2

    Notes
    Fixed
    • enforce db file to be existent before server start (#742) (64a9018)
    • Improved behavioral consistency between the database services (#837) (b6f7187)
  28. v1.7.3

    Fixes 1

    Notes
    Fixed
    • expand reach of cds.features.ieee754compatible to int64 (#722) (7eef5e9)
  29. v1.7.2

    Fixes 1

    Notes
    Fixed
    • deps: update dependency better-sqlite3 to v11 (#669) (7167ec5)
  30. v1.7.1

    Fixes 1

    Notes
    Fixed
    • deps: update dependency better-sqlite3 to v10 (#636) (0cc60e7)
  31. v1.7.0

    Features 1, Fixes 2

    Notes
    Added
    • select decimals as strings if cds.env.features.string_decimals (#616) (39addbf)
    Fixed
    • Change sql property to query for errors (#611) (585577a)
    • Improved placeholders and limit clause (#567) (d5d5dbb)
  32. v1.6.0

    Features 2, Changed 1, Fixes 1

    Notes
    Added
    • forUpdate and forShareLock (#148) (99a1170)
    • hana: drop prepared statements after end of transaction (#537) (b1f864e)
    Fixed
    • sqlite: use keyword list from compiler (#526) (a227c61)
    Changed
    • this package now requires @cap-js/db-service >= v1.7.0 (#545) (2cec27d)
  33. v1.5.1

    Fixes 1

    Notes
    Fixed
    • sqlite: Retain Error object for unique constraint violation (#446) (d27ee79)
  34. v1.5.0

    Features 2, Fixes 5

    Notes
    Added
    • SELECT returns LargeBinaries as streams unless feature flag "stream_compat" is set (#251) (8165a4a)
    • Support Readable Streams inside INSERT.entries (#343) (f6faf89)
    Fixed
    • config in streaming test with compat flag (#412) (335a178)
    • Do not generate UUIDs for association keys (#398) (9970e14)
    • make @cap-js/sqlite work with better-sqlite3@9.3.0 (#422) (44c0a59)
    • sqlite date string compatibility parsing only for valid dates (#410) (2a8bb2d), closes #409
    • UPSERT for @cap-js/hana for entities with multiple keys (#418) (9bbac6e)
  35. v1.4.0

    Features 1, Changed 1, Fixes 2

    Notes
    Added
    • temporal data: add time slice key to conflict clause (#249) (67b8edf)
    Fixed
    Changed
  36. v1.3.1

    Changed 1

    Notes
    Changed
    • Updated minimum required version of @cap-js/db-service.
  37. v1.3.0

    Fixes 1

    Notes
    Fixed
    • CURRENT_TIMESTAMP in view definition preserves the timezone. #254
  38. v1.2.1

    Fixes 1

    Notes
    Fixed
    • Adapt implementation to comply with implication of SQLite version 3.43 which is included in better-sqlite3@8.6.0. #210
  39. v1.2.0

    Changed 1

    Notes
    Changed
    • cds.Decimal and cds.Float return numbers instead of strings
  40. v1.1.0

    Changed 1

    Notes
    Changed
    • Updated minimum required version of @cap-js/db-service.
  41. v1.0.1

    Changed 1

    Notes
    Changed
    • Updated minimum required version of @cap-js/db-service
  42. v1.0.0

    Other 1

    Notes
    • First official release
  43. v0.2.0

    Other 1

    Notes
    • Continuous improvements
  44. v0.1.0

    Other 1

    Notes
    • Initial release
107,842downloads per week, npm
Weekly downloads for @cap-js/sqlite26 complete calendar weeks from 2026-04-20 to 2026-10-18; the latest total is 107842.20 Apr – 26 Apr: 244,02027 Apr – 3 May: 225,5354 May – 10 May: 246,71811 May – 17 May: 250,98818 May – 24 May: 258,26925 May – 31 May: 233,6811 Jun – 7 Jun: 193,1028 Jun – 14 Jun: 256,30015 Jun – 21 Jun: 258,77822 Jun – 28 Jun: 201,00329 Jun – 5 Jul: 247,8976 Jul – 12 Jul: 243,53613 Jul – 19 Jul: 250,47520 Jul – 26 Jul: 246,79627 Jul – 2 Aug: 233,1793 Aug – 9 Aug: 233,95110 Aug – 16 Aug: 187,25117 Aug – 23 Aug: 217,57524 Aug – 30 Aug: 224,29231 Aug – 6 Sept: 174,2407 Sept – 13 Sept: 143,37814 Sept – 20 Sept: 169,13721 Sept – 27 Sept: 207,66128 Sept – 4 Oct: 212,6105 Oct – 11 Oct: 187,23412 Oct – 18 Oct: 107,842
Database connectors
  1. SAP HANA CloudManaged SAP HANA database service on BTP
  2. PostgreSQL on SAP BTP, hyperscaler optionManaged PostgreSQL from the hyperscaler via a BTP service binding
  3. com.sap.cds:cds-feature-hanaSAP HANA Cloud datasource for CAP Java applications
  4. com.sap.cds:cds-feature-jdbcJDBC runtime for H2 and SQLite in CAP Java
  5. com.sap.cds:cds-feature-postgresqlPostgreSQL datasource for CAP Java applications
  6. com.sap.cds:cds-services-bomMaven bill of materials pinning CAP Java module versions
  7. @cap-js/db-serviceBase service shared by CAP's SQLite, PostgreSQL and HANA services
  8. @cap-js/hanaSAP HANA database service for CAP
  9. @cap-js/postgresPostgreSQL database service for CAP
  10. cap-postgres-btp-connectivityTunnels CAP Node.js to a private PostgreSQL via Cloud Connector
  11. cds-mongodbMongoDB as a CAP database service through Mongoose
  12. @cds-pgroll/postgresCLI for DROP and RENAME schema changes beside @cap-js/postgres
  13. @neoimpulse/cap-js-restore-model-defined-typesCAP plugin casting read values back to CDS model types
  14. @quadrio/cds-db2DB2 adapter for CDS
  15. @sap/cds-hanaDatabase adapter for SAP HANA in CAP
  16. @sap/cdsCAP Node.js runtime
  17. @sap/hana-clientSAP's Node.js driver for SAP HANA
  18. SAP HANASAP's relational database platform, on-premise and in HANA Cloud
  19. cds-pgPostgreSQL adapter for SAP CDS from the SAP Mentors community
  20. cap-snowflakeCAP database adapter for Snowflake with OData V4 support
  21. cds-mysqlMySQL and MariaDB database adapter for CAP

Details

Sources5
npm registrydiscovered herechecked
The discovery passdiscovered herechecked
npm registry, @cap-js/sqliteversion, releases, installschecked
github.com/git+https://github.com/cap-js/cds-dbs.gittree, pushes, contributors, CIchecked
sqlite/README.mdquoted, and what the entry declareschecked

Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.

Compatibility and provenance
declared for^10
latestv3.1.2
first release
releases and cadence48, ~12d median
discovered vianpm registry, The discovery pass
first seen in the atlas
ecosystem and domaincap, data-and-persistence
Flavors1
Node.js
“Welcome to the SQLite database service for [SAP Cloud Application Programming Model](https://cap.cloud.sap) Node.js, based on streamlined database architecture and [*better-sqlite* driver](https://www.npmjs.com/package/better-sqlite3).” — cap-js/cds-dbs — sqlite READMEchecked
Contributors35
History in the atlas6
  1. The link named the root of a monorepo, so every crawl read the repository README — 'This is a monorepo for our SQL Database Services' — and filed it as this package's own: data/crawled/readmes/cap-js-sqlite.md is that root README today. npm's record for @cap-js/sqlite declares no repository directory, so the subfolder URL is the only place it can come from, and it is the form the corpus already uses for a package inside a monorepo.
  2. The entry named no registry page, so the only address it offered was a repository it shares with three other packages.
  3. The repository's README states the relation: the four subfolders are parts of one monorepo, each published on its own.
  4. https://github.com/cap-js/cds-dbs/tree/main/sqlite — 'Welcome to the SQLite database service for SAP Cloud Application Programming Model Node.js, based on streamlined database architecture and better-sqlite driver.'
  5. The SQLite service, in memory during the inner loop — which is why a CAP project runs before anyone has provisioned a database.
  6. First seen.
For your agent
Ref
artifact:cap-js-sqlite
JSON
/artifacts/cap-js-sqlite.json
MCP
Connecting an agent