async def _get_tables(self, schema: str) -> List[str]:
        """Get list of tables in a schema.

        Args:
            schema: Schema name

        Returns:
            List of table names
        """
        async with self.pool.acquire() as conn:
            async with conn.cursor() as cursor:
                query = """
                    SELECT TABLE_NAME
                    FROM INFORMATION_SCHEMA.TABLES
                    WHERE TABLE_SCHEMA = %s
                    AND TABLE_TYPE = 'BASE TABLE'
                """
                await cursor.execute(query, (schema,))
                tables = await cursor.fetchall()
                return [table[0] for table in tables]
Get list of tables in a schema.

        Args:
            schema: Schema name

        Returns:
            List of table names
        
backend/airweave/platform/sources/mysql.py