Urban energy modeling currently faces two critical obstacles: (1) the lack of an extensible, standardized platform that allows researchers to easily define and integrate custom building feature calculation methods beyond a fixed set of functions, which is necessary to overcome the challenge of sparse and heterogeneous data resources; and (2) the inaccessibility of complex PostGIS spatial SQL to non-technical users, which severely limits efficient data querying and analysis. This thesis presents a comprehensive framework to address these issues through two integrated, open-source systems: CIM Wizard Integrated, an object-oriented platform for city information modeling, and CIM Assist, an LLM-powered natural language interface for spatial data access.