MySQL

Extracts tables and their columns from every database on a MySQL server. Emits table entities, plus references edges for foreign keys.

Usage

source:
  name: mysql
  scope: my-scope
  config:
    connection_url: admin:pass123@tcp(localhost:3306)/

Key	Type	Description	Required
`connection_url`	`string`	MySQL connection URL, in Go DSN format.	Yes
`exclude.databases`	`[]string`	Database names to skip.	No
`exclude.tables`	`[]string`	Tables to skip, in `database.table` format.	No

Entity type: table

URN pattern: urn:mysql:{scope}:table:{database}.{table}

Notable properties:

columns - List of column objects. Each has name, data_type, is_nullable, description (the column comment, omitted when empty), and length (omitted when zero).

Edge type	From	To
`references`	table	table

One references edge is created per foreign key, pointing from the table to the table it references.

The system databases information_schema, mysql, performance_schema, and sys are always skipped.