PHPackages nimmermaer/statica - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. nimmermaer/statica ActiveTypo3-cms-extension[Database & ORM](/categories/database) nimmermaer/statica ================== Export tables to static sql dump to provider extension v14.x-dev(4mo ago)10GPL-2.0-or-laterPHP Since Nov 23Pushed 1mo agoCompare [ Source](https://github.com/Nimmermaer/statica)[ Packagist](https://packagist.org/packages/nimmermaer/statica)[ RSS](/packages/nimmermaer-statica/feed)WikiDiscussions main Synced 1mo ago READMEChangelogDependencies (1)Versions (2)Used By (0) EXT:statica =========== [](#extstatica) [![TYPO3 13](https://camo.githubusercontent.com/2cf6570821614808899422f68a66a381a2de1dd0746ba9cdba6155def1f4f396/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5459504f332d31332d6f72616e67652e737667)](https://get.typo3.org/version/13) `EXT:statica` is a TYPO3 development extension designed to **export and import** static SQL data from `ext_tables_static+adt.sql` files. Its main purpose is to allow developers to **version-control static database data** (e.g., `be_users`, or any other table) directly inside an extension. > ⚠️ **Important:** This extension is intended **only for development environments**. > It should be installed using Composer's `--dev` flag and removed before deployment to production. --- Features -------- [](#features) - Export any table(s) into an extension's `ext_tables_static+adt.sql`file for version control\\ - Import static SQL data back into the database using a CLI command\\ - No relation resolving (MM tables, inline relations, foreign keys) → **Relations must be handled manually by the developer** - Extends TYPO3 Core's `SQLReader` class to better interpret comment styles found in ADT dumps (especially MySQL conditional comments generated by `mysqldump`) - Future feature: Enable or disable commands depending on the environment (e.g., dev/stage/prod) --- Installation ------------ [](#installation) ``` composer require vendor/statica --dev ``` Because the extension is meant only for development workflows, it should always be installed using the `--dev` flag and excluded from production deployments. --- Usage ----- [](#usage) ### Export static data [](#export-static-data) Export one or multiple tables into an extension's `ext_tables_static+adt.sql` file: ``` bin/typo3 statica:static-export ``` **Example:** ``` bin/typo3 statica:static-export my_site_package be_users,tx_news_domain_model_news ``` This writes the exported SQL into: ``` EXT:my_site_package/ext_tables_static+adt.sql ``` --- ### Import static data [](#import-static-data) Import the static SQL from `ext_tables_static+adt.sql` into the database: ``` bin/typo3 statica:static-import ``` **Example:** ``` bin/typo3 statica:static-import my_site_package ``` --- Limitations ----------- [](#limitations) - No relationship resolution - MM tables must be exported separately\\ - Inline and foreign-key relations are **not automatically handled** - Only meant for development - Do **not** use this extension in production\\ - Remove the package before releasing --- Roadmap ------- [](#roadmap) Future improvements may include: - Auto-hiding or enabling CLI commands based on environment (e.g., allow export only in `development`) - Additional validation for SQL dumps - Extended support for multi-table dependency handling --- License ------- [](#license) MIT License (or your chosen license) --- Disclaimer ---------- [](#disclaimer) This extension is intended for **development workflows only**. Accidental import operations in production may lead to **data loss**. Use with caution and remove before deployment. ### Health Score 29 — LowBetter than 59% of packages Maintenance85 Actively maintained with recent releases Popularity2 Limited adoption so far Community6 Small or concentrated contributor base Maturity21 Early-stage or recently created project Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Unknown Total 1 Last Release 127d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/2128616b432e20e9b9c994ab9bb8ef7a7a06fcf22b74eaefe1e9cc2ac860028a?d=identicon)[Nimmermaer](/maintainers/Nimmermaer) --- Top Contributors [![Nimmermaer](https://avatars.githubusercontent.com/u/4773406?v=4)](https://github.com/Nimmermaer "Nimmermaer (1 commits)") ### Embed Badge ![Health badge](/badges/nimmermaer-statica/health.svg) ``` [![Health](https://phpackages.com/badges/nimmermaer-statica/health.svg)](https://phpackages.com/packages/nimmermaer-statica) ``` ### Alternatives [in2code/migration Framework for any kind of TYPO3 migrations and imports. Also exports and imports content from and to json files. 6277.0k3](/packages/in2code-migration)[lolli/dbdoctor TYPO3 Database doctor - Find and fix TYPO3 database inconsistencies 43103.5k](/packages/lolli-dbdoctor)[friendsoftypo3/typo3db-legacy TYPO3\_DB compatibility layer 12521.7k5](/packages/friendsoftypo3-typo3db-legacy)[bmack/site-importer Imports records from a Yaml file structure into the TYPO3 database 2383.2k](/packages/bmack-site-importer)[stefanfroemken/mysqlreport Analyze and profile your TYPO3 databases queries 1314.9k](/packages/stefanfroemken-mysqlreport) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)