datastore

Local SQLite datastore tools: create tables, insert data, run SQL queries, list tables, inspect schemas, and drop tables. Persists data across server restarts at ~/.mcp-canada/datastore.db.

6tools

All tools accept lang: "en" | "fr". Open each tool below for its source-derived parameters.

`ds_create_table`

Create a named table in the local SQLite datastore.

Use forcreating tables to store data from any source, setting up

datastore, create, table, sqlite, store, persist, schema, columns, local, database

Parameter	Type	Default
`table_name`	`str`	`required`
`columns`	`list[dict] \| None`	`None`
`data`	`list[dict] \| None`	`None`
`lang`	`Literal['en', 'fr']`	`'en'`

`ds_insert_data`

Insert rows of data into an existing table in the local SQLite datastore.

Use forstoring fetched data, saving agent results, or populating

datastore, insert, rows, data, store, sqlite, write, append, persist, save, record, bulk

Parameter	Type	Default
`table_name`	`str`	`required`
`rows`	`list[dict]`	`required`
`lang`	`Literal['en', 'fr']`	`'en'`

`ds_query`

Run a read-only SQL query against the local SQLite datastore.

Use forretrieving, filtering, joining, or aggregating data stored in

datastore, query, select, sql, sqlite, search, filter, retrieve, join, aggregate, rows, results

Parameter	Type	Default
`sql`	`str`	`required`
`lang`	`Literal['en', 'fr']`	`'en'`

`ds_list_tables`

List all tables in the local SQLite datastore.

Use fordiscovering what tables exist in the local datastore, checking

datastore, list, tables, show, sqlite, catalog, discover, available, names, database

Parameter	Type	Default
`lang`	`Literal['en', 'fr']`	`'en'`

`ds_get_schema`

Get the column schema for a table in the local SQLite datastore.

Use forinspecting the structure of an existing table, verifying column

datastore, schema, columns, structure, sqlite, table, describe, inspect, types, definition, metadata, info

Parameter	Type	Default
`table_name`	`str`	`required`
`lang`	`Literal['en', 'fr']`	`'en'`

`ds_drop_table`

Drop (delete) a table from the local SQLite datastore.

Use forremoving tables that are no longer needed, cleaning up

datastore, drop, delete, remove, table, sqlite, cleanup, reset, destroy, clear, purge, truncate

Parameter	Type	Default
`table_name`	`str`	`required`
`lang`	`Literal['en', 'fr']`	`'en'`