MetaTables
MetaTables is a Python client and API for describing, registering, querying, and updating database tables through a governed catalog.
Its PyPI distribution is mainsequence-metatable; imports and the command are
named metatables. See publishing for the
release process and the current published SDK prerequisite.
The Python client provides SQLAlchemy table definitions, application-table
migrations, query objects, time-index readers and update processes,
and the metatables command. The MetaTables API stores table identities,
contracts, permissions, and update history, and executes authorized operations on
physical databases.
A catalog record describes a table; the table's rows live in its DataSource. The Main Sequence SDK supplies platform authentication, identity, repository context, and platform Secrets. MetaTables owns its table behavior and storage adapters. Local development runs the same API with one SQLite database for system metadata and table rows. Initialize it explicitly through Settings; startup never runs Alembic.
Start here
- Install and connect, including the complete local CLI workflow.
- Understand the concepts and identity and scope.
- Understand the security model: administration, Reader/Writer table ownership, sharing, and implementation status.
- Follow the market-data tutorial with its complete examples folder.
- Define and migrate managed tables.
- Register existing tables.
- Manage DataSources: PostgreSQL, MySQL and MSSQL configuration, driver setup, examples and current operation limits.
- Build an updater or read an existing time-index table.
- Run the API locally or operate a hosted API.
The documentation index separates client, API, operations, and contributor guides. The capability reference records implemented and unavailable operations, including inherited methods and CLI commands. Runnable guide assets live in examples.
Client skills
Copy the installed client's skills into a consuming application explicitly:
metatables copy-metatables-skills --path /path/to/application
The local development skill guides application work through local SQLite setup, verified test writes, and an explicit switch back to the intended environment. The other skills cover table contracts, application migrations and producers.
The command uses the Main Sequence SDK helper, writes to
.agents/skills/metatables/, and records the client version. It works without
login or an API. Use --dry-run to preview the copy, or put global --json before
the command for structured output. See installation
for refresh behavior and the bundled references.
Development
Python 3.13 or newer is required. The package selects the published compatible SDK:
python -m pip install -e '.[dev,docs]'
python -m metatables.sdk_compat
python -m pytest -q
python -m scripts.check_project
mkdocs build --strict
Physical PostgreSQL checks use explicitly configured disposable databases; see testing. No separate frontend is needed to use the Python client or run the API.
License
MetaTables is licensed under the MIT License. See LICENSE for the complete terms.
1 maintainer
Metadata
1 maintainer
Release files for mainsequence-metatable 0.1.20
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| mainsequence_metatable-0.1.20.tar.gz | 1.0 MB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| mainsequence_metatable-0.1.20-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 3.0 MB
Release files / mainsequence_metatable-0.1.20.tar.gz
| Download URL | mainsequence_metatable-0.1.20.tar.gz |
|---|---|
| Size | 1.0 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
2fd596520e506c517e948d2ee0b05a966c022fc7a1d74749d6e988080a035dd3
|
|
BLAKE2b-256 checksum How to use checksums |
59061665f32af705c53111e22380660a9805b04e1d22ffa524930a24958c7fe7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 4, 2026.
Transparency logRelease files / mainsequence_metatable-0.1.20-py3-none-any.whl
| Download URL | mainsequence_metatable-0.1.20-py3-none-any.whl |
|---|---|
| Size | 2.0 MB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
21de050ccb1ad325655f7b856434ae3675d22c1ee149a18b3bcc3c1781f8c966
|
|
BLAKE2b-256 checksum How to use checksums |
1c40b643b0d366f491605c51a3e2028117c3afd9b46b1811cbaa478dd172a754
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Oct 4, 2026.
Transparency log
