information_schema
stores metadata of all the objects such as handlers, databases, AI engines, models, jobs, and more.log
stores log data of models and jobs.files
, which is initially empty, stores all files uploaded to MindsDB.mindsdb
is the default project for storing models, views, jobs, triggers, and agents.information_schema
Databaseinformation_schema
database contains all the system tables that correspond to MindsDB objects as follows:
Name | Description |
---|---|
HANDLERS | Stores all (data and AI) handlers, which are data integrations and AI integrations supported by MindsDB. |
DATABASES | Stores all data sources connected to MindsDB. Note that corresponding handlers are required, and you can connect only the data sources supported by MindsDB after installing the required handler dependencies. |
ML_ENGINES | Stores all AI/ML engines configured at MindsDB. Note that corresponding handlers are required, and you can connect only the AI/ML engines supported by MindsDB after installing the required handler dependencies. |
MODELS | Stores all models deployed within the MindsDB ecosystem. Note that you can create and deploy a model only after configuring the corresponding AI/ML engine. |
VIEWS | Stores all views created in MindsDB. |
JOBS | Stores all jobs that facilitate workflow automation. |
TRIGGERS | Stores all triggers that facilitate workflow automation. |
AGENTS | Stores all AI agents created in MindsDB. |
SKILLS | Stores all skills that can be assigned to AI agents. |
KNOWLEDGE_BASES | Stores all knowledge bases that can be assigned to AI agents as skills. |
CHATBOTS | Stores all chatbots that comprise an AI agent and a chat interface. |
DATABASES
, ML_ENGINES
, and MODELS
, may contain sensitive information in the form of API keys or passwords. MindsDB hides this sensitive information by default.If you want to expose this sensitive information in the output when querying these objects, set the show_secrets
flag to true
.false
.SHOW
command to list all objects as follows:
mindsdb
project that contain ai
in its name.
IMPORT_SUCCESS
column reads true. If it reads false, then install the dependencies for this handler before using it.mindsdb
Projectmindsdb
project where all objects created without defining a project are stored.
Learn more about how to create and manage projects here.
files
Database