sqlalchemy 查询SQL：

#/usr/bin/env python
#coding:utf-8
from sqlalchemy import create_engine,text
engine = create_engine("mysql+pymysql://dbname:dbpassword@ip:3306/db?charset=utf8",encoding="utf-8",echo=True)
conn = engine.connect()
text_sql='show index from table_name'
s=text(text_sql)
conn.execute(s)
# print conn.execute(s).fetchall()

sqlalchemy 获取所有索引 index：

from sqlalchemy import MetaData, inspect, create_engine
from sqlalchemy.engine import reflection
engine = create_engine("mysql+pymysql://dbname:dbpassword@ip:3306/db?charset=utf8",encoding="utf-8",echo=True)
insp = reflection.Inspector.from_engine(engine)
#获取所有索引
ind=insp.get_indexes("table_name")
print(ind)

sqlalchemy 获取唯一索引 unique index：

from sqlalchemy.engine import reflection
engine = create_engine("mysql+pymysql://dbname:dbpassword@ip:3306/db?charset=utf8",encoding="utf-8",echo=True)
insp = reflection.Inspector.from_engine(engine)
#获取唯一索引
ind=insp.get_unique_constraints("table_name")
print(ind)

其它：通过解析建表语句，获得unique index