from typing import List
from typing import Dict


def str_to_sql_dict(tables: List[str]) -> List[Dict]:

    """
    Transforms a list of tables/procedures names into a list of dictionaries with keys schema and name

    :param tables: list ot table names
    :return: list of table dictionaries
    """

    return [dict(zip(['schema', 'name'], t.lower().split('.'))) for t in tables]